FULL

FULL Hint

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 24th May 2022