Page 1 of 1

Having multiple indexes on a table ???

Posted: Thu Dec 29, 2011 1:56 pm
by sonakasi
Hi all,

In our project, we have a table, which is having too many index and I think having too many index will affect performance.
Can some one explain if this right and the reason ??

Posted: Thu Dec 29, 2011 3:37 pm
by dbzTHEdinosauer
you can not make blanket statements like that and expect them to have any meaning without qualification.

of course an index requires resources.

but if a business need exists for that index, then it must be implemented in a manner
that does not affect the business throughput.

the art of programming does not end with the finding of 'problems'
that is where the art starts: fixing the problem.

Posted: Fri Dec 30, 2011 10:30 am
by DikDude
Why does someone believe there are "too many indesex"?

I am not aware of any document that says what is ok and what is too many.

As with most things, "it depends". Again, if there is some specific question, please post the question (which would need lots of suppoprting detail info) and possibly someone will have a suggestion.