Hi Experts,
Recently, our database got migrated to Exadata environment, and a DBA told me that using the /*+ FULL */ hint in the query increases the query performance.
Doubt -
1) Does it actually enhance performance?
2) I read some articles and got some information that Exadata does some kind of "Smart Scan" and "Cell Offloading" which makes the query efficient. But how does FULL hint contribute here?
This links talks something about this, but not sure if correct - Some Hints for Exadata SQL Tuning - Part III - SQL Optimizer for Oracle - SQL Optimizer for Oracle - Toad World
Please share your thoughts and advise.
Thanks and Regards,
-- Ranit
( on Oracle 11.2.0.3.0 - Exadata )