Home » RDBMS Server » Server Administration » How to find non-indexed queries and columns that require indexes
How to find non-indexed queries and columns that require indexes [message #521718] Thu, 01 September 2011 09:54 Go to next message
adnan_wns
Messages: 7
Registered: July 2011
Junior Member
How to find non-indexed queries and columns that require indexes??

Please reply me as soon as possible

Report message to a moderator

Re: How to find non-indexed queries and columns that require indexes [message #521719 is a reply to message #521718] Thu, 01 September 2011 09:56 Go to previous messageGo to next message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

>How to find non-indexed queries and columns that require indexes??
inspect the SELECT statements

Report message to a moderator

Re: How to find non-indexed queries and columns that require indexes [message #521738 is a reply to message #521719] Thu, 01 September 2011 11:16 Go to previous messageGo to next message
cookiemonster
Messages: 13920
Registered: September 2008
Location: Rainy Manchester
Senior Member
And realise that queries don't always benefit from indexes.

Report message to a moderator

Re: How to find non-indexed queries and columns that require indexes [message #521739 is a reply to message #521738] Thu, 01 September 2011 11:21 Go to previous message
BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal
Senior Member
when all else fails Read The Fine Manual

http://download.oracle.com/docs/cd/B19306_01/server.102/b14231/schema.htm#sthref2113

Report message to a moderator

Previous Topic: Switch between disks in a diskgroup
Next Topic: v$session view (merged 2)
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Tue Apr 23 20:46:12 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.