Home » SQL & PL/SQL » SQL & PL/SQL » how we create index
how we create index [message #273301] Tue, 09 October 2007 22:30 Go to next message
ashishmcajec
Messages: 20
Registered: April 2007
Location: Mumbai
Junior Member
How we create index as i am facing one problem when i execute plan it show me full table scan while i am making index it say index already created?
Re: how we create index [message #273303 is a reply to message #273301] Tue, 09 October 2007 22:33 Go to previous messageGo to next message
BlackSwan
Messages: 25050
Registered: January 2009
Location: SoCal
Senior Member
http://www.orafaq.com/forum/t/88153/0/

Your post is the equivalent to me saying the following:
My car has a problem. It does not go. Tell me how to fix my problem.

[Updated on: Tue, 09 October 2007 22:42] by Moderator

Report message to a moderator

Re: how we create index [message #273308 is a reply to message #273303] Tue, 09 October 2007 22:54 Go to previous messageGo to next message
rleishman
Messages: 3724
Registered: October 2005
Location: Melbourne, Australia
Senior Member
So you are saying that your index exists, but Oracle is not using it, right?

Could be a lot of reasons. Work through them here.

If you still cannot work it out, post your query and explain plan.

Ross Leishman
Re: how we create index [message #273837 is a reply to message #273308] Thu, 11 October 2007 19:16 Go to previous message
skumar.dba
Messages: 82
Registered: October 2007
Member
Hi rleishman,

Thanks for providing very good information. it helped me alot. thank you so much...
Previous Topic: index using PL/SQL
Next Topic: pl/sql
Goto Forum:
  


Current Time: Sat Dec 10 13:06:39 CST 2016

Total time taken to generate the page: 0.07747 seconds