hi ,
I wanted to know whether it is better (speed-wise) to have more
indexes .Or one should try to have less number of them , so that
as much as possible all can be stored 'in-memory'? Or is it
that they are loaded 'in-memory' only after the analyzer
decides which of them to use?
I am having 12 indexes on 6 tables(they are huge with 0.5 million
rows in each).
thanks for any help
--
------
Varun
Why doesn't DOS ever say "EXCELLENT command or filename!"