Home » RDBMS Server » Performance Tuning » What if index using index is not sufficient
What if index using index is not sufficient [message #65882] Thu, 20 January 2005 19:10 Go to next message
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
Re: What if index using index is not sufficient [message #65884 is a reply to message #65882] Thu, 20 January 2005 21:13 Go to previous messageGo to next message
Frank
Messages: 7880
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
Re: What if index using index is not sufficient [message #65887 is a reply to message #65884] Thu, 20 January 2005 23:37 Go to previous messageGo to next message
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.
Re: What if index using index is not sufficient [message #65888 is a reply to message #65887] Fri, 21 January 2005 01:32 Go to previous messageGo to next message
Frank
Messages: 7880
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 ?
Re: What if index using index is not sufficient [message #65889 is a reply to message #65882] Fri, 21 January 2005 03:58 Go to previous message
Mahesh Rajendran
Messages: 10694
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?
Previous Topic: SLOW TABLE DROPS
Next Topic: join conditions for smaller /larger tables
Goto Forum:
  


Current Time: Sun Jan 17 13:14:08 CST 2021