OraFAQ Forum: Performance Tuning » What if index using index is not sufficient

Home » RDBMS Server » Performance Tuning » What if index using index is not sufficient

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

What if index using index is not sufficient [message #65882]

Thu, 20 January 2005 19:10

Vinu
Messages: 13
Registered: March 2003

Junior Member

Dear All,
A query is using the index provided properly. But it still is a bottleneck in the application. Is there any alternative in this situation?

Regards,
Vinu

Report message to a moderator

Re: What if index using index is not sufficient [message #65884 is a reply to message #65882]

Thu, 20 January 2005 21:13

Frank
Messages: 7901
Registered: March 2000

Senior Member

Some open doors:

- Index <> Fast, at least not always.
- There is always 1 most expensive statement in every application

If your statement is expensive, and it is 'tuned to the bone', see if you can change your logic, causing the statement to be executed less often.

hth

Report message to a moderator

Re: What if index using index is not sufficient [message #65887 is a reply to message #65884]

Thu, 20 January 2005 23:37

Vinu
Messages: 13
Registered: March 2003

Junior Member

But Frank,
I will be carrying heavy overhead on the disk IO side if i use a lot of indexes.

Regards,
vinu.

Report message to a moderator

Re: What if index using index is not sufficient [message #65888 is a reply to message #65887]

Fri, 21 January 2005 01:32

Frank
Messages: 7901
Registered: March 2000

Senior Member

Who said 'use a lot of indexes'?

And what do you mean using indexes will cause heavy I/O overhead ?

Report message to a moderator

Re: What if index using index is not sufficient [message #65889 is a reply to message #65882]

Fri, 21 January 2005 03:58

Mahesh Rajendran
Messages: 10707
Registered: March 2002
Location: oracleDocoVille

Senior Member
Account Moderator

As frank said, how do you say that there is a bottleneck with indexes?
Is there any measurable unit here?
a statspack report or trace output?

Report message to a moderator

Previous Topic:	SLOW TABLE DROPS
Next Topic:	join conditions for smaller /larger tables

Goto Forum:

-=] Back to Top [=-

[ Syndicate this forum (XML) ] [

]

Current Time: Thu Apr 18 07:54:50 CDT 2024