oracle-wiki.net - Full Hint

The New Home of Oracle-wiki.net

All things oracle...

A website for IT Professionals involved with Oracle database.

Back

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

Page updated

Google Sites

Report abuse