On Hints

 

Popularly used hints:

`SELECT /*+ GATHER_PLAN_STATISTICS */
SELECT /*+ INDEX */ 
SELECT /*+ OPTIMIZER_FEATURES_ENABLE */
SELECT /*+ FIRST_ROWS */ 
INSERT /*+ APPEND */ 
`

Links for further reading on hints :

 http://msutic.blogspot.sg/2009/08/sql-tuning-using-usehash-hint-dblink.html

http://allthingsoracle.com/a-beginners-guide-to-optimizer-hints/

http://sbhoracle.wordpress.com/2011/04/27/oracle-hints/

Advertisements

Leave a Reply

Fill in your details below or click an icon to log in:

WordPress.com Logo

You are commenting using your WordPress.com account. Log Out / Change )

Twitter picture

You are commenting using your Twitter account. Log Out / Change )

Facebook photo

You are commenting using your Facebook account. Log Out / Change )

Google+ photo

You are commenting using your Google+ account. Log Out / Change )

Connecting to %s