Home » RDBMS Server » Performance Tuning » Hint Index
Hint Index [message #197557] Wed, 11 October 2006 15:04 Go to next message
lsabster
Messages: 2
Registered: October 2006
Location: New Jersey
Junior Member
Hello,

The original hint is as follows:

(/*!HINT INDEX (TABLE_INTERACT
CREATE_DATE_INDEX)*/1=1)


With this hint, the database is running fine.


The modified hint (whether unintentional or not) is as follows:

(/*!HINT INDEX (TABLE_INTERACT
CREATE_DATE_INDEX)*/ 1=1)


Note that there is now a space after the "/" symbol before the "1". Now the query runs 5 hours longer. This is a remote site, so I don't have access to play around. My question is would the space be a reason why the query is taking long. Is the Hint invalid now, I know that Oracle doesn't really give a message if the hint is unuseable? What does the 1=1 mean? Please help.

thank you.

Report message to a moderator

Re: Hint Index [message #197564 is a reply to message #197557] Wed, 11 October 2006 17:38 Go to previous messageGo to next message
rleishman
Messages: 3728
Registered: October 2005
Location: Melbourne, Australia
Senior Member
Unless there is an alternate hint syntax that has escaped my attention, this is invalid. I would say that your hint was NEVER being used.
Take a look at the Performance Tuning Manual.
Ross Leishman

Report message to a moderator

Re: Hint Index [message #197764 is a reply to message #197557] Thu, 12 October 2006 10:27 Go to previous message
lsabster
Messages: 2
Registered: October 2006
Location: New Jersey
Junior Member
Thank you!

Report message to a moderator

Previous Topic: dbms_session.set_sql_trace_in_session('12,25')
Next Topic: Query Takes More time To Run
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Mon May 06 05:59:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.