Home » RDBMS Server » Performance Tuning » To Tune or To use Hints (merged)
To Tune or To use Hints (merged) [message #413462] Wed, 15 July 2009 20:21 Go to next message
ap_karthi
Messages: 87
Registered: October 2007
Location: Bangalore
Member
Hello,

1. A Table contains 40 columns and 20 million rows(records).
Only one column have '*' (asterisk) as data in all the 20 million rows for some reason.
2. When I ran Oracle Tuning Advisor in Toad, it says create an index for this column which contains '*'.

3. My question is what type of index should be created?
4. Whether /*+HINTS*/ will be helpful?
Pls suggest. Thanks

-Karthik
Re: To Tune or To use Hints [message #413465 is a reply to message #413462] Wed, 15 July 2009 20:33 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
>. When I ran Oracle Tuning Advisor in Toad, it says
If it told you to stand on your head in the corner of the room,
would you do so?

Is this column used in any WHERE clause?
If not, then no index is needed.
If so, post the SQL.
Re: To Tune or To use Hints [message #413467 is a reply to message #413462] Wed, 15 July 2009 20:53 Go to previous messageGo to next message
BlackSwan
Messages: 25039
Registered: January 2009
Location: SoCal
Senior Member
Follow Posting Guidelines & do not cross/multi-post!

You need to help us by following the Posting Guidelines as stated below.
http://www.orafaq.com/forum/t/88153/0/
Go to the URL above click the link "Posting Guidelines"
Go to the section labeled "Practice" & do as directed.

[Updated on: Wed, 15 July 2009 20:57]

Report message to a moderator

Re: To Tune or To use Hints [message #413470 is a reply to message #413467] Wed, 15 July 2009 22:36 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
An index will only speed up identifiction of a REDUCED row set. If every row has the same value, then any WHERE clause you apply on the column will not reduce the results. An index is likely to be useless.

Ross Leishman
Re: To Tune or To use Hints (merged) [message #413473 is a reply to message #413462] Wed, 15 July 2009 23:20 Go to previous message
Michel Cadot
Messages: 64117
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
I recommend you to read:
- Performances -Tuning sticky and link related to indexes
- Database Performance Tuning Guide
- http://www.orafaq.com/forum/m/382787/102589/

Regards
Michel

[Updated on: Wed, 15 July 2009 23:35]

Report message to a moderator

Previous Topic: Enable 10053 Trace information
Next Topic: Force the optimizer to use the primary key index
Goto Forum:
  


Current Time: Tue Dec 06 04:28:29 CST 2016

Total time taken to generate the page: 0.11847 seconds