Re: indexing issue, need alternate solution to improve the query performance

Take a copy of the table to a test table.

Create indexes until you are happy. Or, probably drop indexes until you are happy.
More indexes mean slower insert.

No indexes, faster insert.
Try gathering stats on the table... that may or may not improve performance depends on what is there.

test test test
Then test again.

And finally one last test before you test it just before putting it into production. Received on Mon Mar 20 2006 - 20:53:22 CST