OraFAQ Forum: SQL & PL/SQL

Home » SQL & PL/SQL » SQL & PL/SQL » Index usage (10g)

Show: Today's Messages :: Show Polls :: Message Navigator
E-mail to friend

Index usage [message #574463]

Thu, 10 January 2013 11:12

saipradyumn
Messages: 131
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

Report message to a moderator

Re: Index usage [message #574464 is a reply to message #574463]

Thu, 10 January 2013 11:14

BlackSwan
Messages: 20086
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/

Report message to a moderator