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.
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: 3724
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
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!
Previous Topic: dbms_session.set_sql_trace_in_session('12,25')
Next Topic: Query Takes More time To Run
Goto Forum:
  


Current Time: Sun Dec 11 00:37:47 CST 2016

Total time taken to generate the page: 0.19550 seconds