The New Home of Oracle-wiki.net

All things oracle...

A website for IT Professionals involved with Oracle database.

LinkLinkedIn

FULL

Full Hint Description

The FULL hint forces the Oracle to perform a full table scan for the table specified.



Example

SELECT /*+ FULL(a) */ col1, col2

  FROM MyTab a

  WHERE col1 LIKE '%hey%'

/

Published on 

Published 24th May 2022