Home » RDBMS Server » Server Administration » SQL Hint
SQL Hint [message #215965] Wed, 24 January 2007 07:55 Go to next message
humair77
Messages: 13
Registered: August 2005
Junior Member
If a program creates a temporary index for a table, and then later uses that table but without including a 'Hint' that the temp index is to be used, will Oracle use that temp index? Or will it only use the index if the Hint is included in the Select statement?
Re: SQL Hint [message #215972 is a reply to message #215965] Wed, 24 January 2007 08:41 Go to previous message
joy_division
Messages: 4642
Registered: February 2005
Location: East Coast USA
Senior Member
Duplicate post.
Previous Topic: Is it possible to Rollback any applied / unsuccessfully applied PATCH
Next Topic: urgent! Verify that the TNS name in the connectstring entry of the DAD for this URL is valid.
Goto Forum:
  


Current Time: Thu Dec 08 04:10:35 CST 2016

Total time taken to generate the page: 0.17466 seconds