Home » SQL & PL/SQL » SQL & PL/SQL » Index usage (10g)
Index usage [message #574463] Thu, 10 January 2013 11:12 Go to next message
saipradyumn
Messages: 187
Registered: October 2011
Location: Hyderabad
Senior Member
Hi All ,

I have an index on column of table which of data type varchar2. While selecting data from that table I am using following scenarios
in where on the indexed column

like '%abc%'
like 'abc%'
like '&abc'

Will be the corresponding index will be for those cases?

Thanks
Saipradyumn
Re: Index usage [message #574464 is a reply to message #574463] Thu, 10 January 2013 11:14 Go to previous messageGo to next message
BlackSwan
Messages: 23059
Registered: January 2009
Senior Member
>Will be the corresponding index will be for those cases?
post EXPLAIN PLAN for each query & you will have your answers.

Please read and follow the forum guidelines, to enable us to help you:

http://www.orafaq.com/forum/t/88153/0/
Re: Index usage [message #574465 is a reply to message #574463] Thu, 10 January 2013 11:17 Go to previous messageGo to next message
Michel Cadot
Messages: 59794
Registered: March 2007
Location: Nanterre, France, http://...
Senior Member
Account Moderator
Once again, we don't do homework.

Performance Tuning Guide
Chapter 19 Using EXPLAIN PLAN

Regards
Michel
Re: Index usage [message #574468 is a reply to message #574463] Thu, 10 January 2013 11:46 Go to previous message
Solomon Yakobson
Messages: 2064
Registered: January 2010
Senior Member
All three could use depending on situation.

SY.
Previous Topic: Going through record set in oracle and doing calculations
Next Topic: Multiple Values in Column
Goto Forum:
  


Current Time: Wed Nov 26 17:12:31 CST 2014

Total time taken to generate the page: 0.12288 seconds