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?

Report message to a moderator

Re: SQL Hint [message #215972 is a reply to message #215965] Wed, 24 January 2007 08:41 Go to previous message
joy_division
Messages: 4963
Registered: February 2005
Location: East Coast USA
Senior Member
Duplicate post.

Report message to a moderator

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:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Sep 20 04:36:57 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.