Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Reg: Exadata and /*+ FULL */ hint -

915396Jun 25 2014 — edited Jun 30 2014

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 )

Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Jul 28 2014
Added on Jun 25 2014
9 comments
6,580 views