OraFAQ Forum: Performance Tuning » which index is best for query performance

Home » RDBMS Server » Performance Tuning » which index is best for query performance (Oracel 11.1 Red Hat )

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

which index is best for query performance [message #482565]

Fri, 12 November 2010 10:41

nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR

Member

Hi

I create a view on production server which takes almost 10 to 12 minutes when it shows data. this view contains 3 or 4 tables on which all primary and unique columns have indexes.
Can you please suggest me which index will be better for fast retrieval of data .
thanks

Report message to a moderator

Re: which index is best for query performance [message #482566 is a reply to message #482565]

Fri, 12 November 2010 10:45

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

>Can you please suggest me which index will be better for fast retrieval of data .
you need an index on the third column.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

post EXPLAIN PLAN

Report message to a moderator

Re: which index is best for query performance [message #482569 is a reply to message #482566]

Fri, 12 November 2010 11:14

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Third and fourth ones should be better.

Read http://www.orafaq.com/forum/mv/msg/84315/433888/102589/#msg_433888 and post the required information.

Regards
Michel

[Updated on: Fri, 12 November 2010 11:15]

Report message to a moderator

Re: which index is best for query performance [message #482587 is a reply to message #482569]

Sat, 13 November 2010 00:40

nehaverma
Messages: 80
Registered: January 2010
Location: JAIPUR

Member

hi
What is the meaning of this third and forth column as you said and I did not create any explain paln on that view.
i want to increase performance of this view by including index on that table which are used by this view.

Report message to a moderator

Re: which index is best for query performance [message #482588 is a reply to message #482587]

Sat, 13 November 2010 01:05

Michel Cadot
Messages: 68647
Registered: March 2007
Location: Nanterre, France, http://...

Senior Member
Account Moderator

Do as requested.

Regards
Michel

Report message to a moderator

Re: which index is best for query performance [message #482592 is a reply to message #482588]

Sat, 13 November 2010 08:23

BlackSwan
Messages: 26766
Registered: January 2009
Location: SoCal

Senior Member

I don't know what you have.
I don't know what you do.
I don't know what you see.
It is really, Really, REALLY difficult to fix a problem that can not be seen.
use COPY & PASTE so we can see what you do & how Oracle responds.

It would be helpful if you followed Posting Guidelines - http://www.orafaq.com/forum/t/88153/0/

Report message to a moderator

Previous Topic:	Order by Clause is too slow
Next Topic:	Oracle Row Chaining and Migration

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Sun Apr 28 08:06:09 CDT 2024