Hi Ram,
Since you don't want to be indexing all the columns the only
suggestion I have is to monitor the sql issued against the table, via
v$sqlarea etc. and index two or three of the most commonly used where
clause columns. That way the majority of your queries should hopefully
have improved response times. Any other users experiencing problems
may then either contact you directly for suggestions on improving the
query or, even better, find that they can be more selective in the
query and use one of the indexed columns.
Regards,
Rob
Received on Mon Mar 20 2006 - 09:16:14 CST
