I am slightly confused by some information that I got today. My
understanding is that all our customers are using the rule-based optimizer.
Recently, we added some indexes to a couple of tables to improve
performance. Approx a week later the performance was as bad as before we put
the indexes on. The information fed back to me was that the statistics on
the index had to be updated.
So the immediate question which comes to mind is:
Do indexes use statistics even if the rule based optimizer is being used?.
If this is the case, would dropping and recreating the index not have the
same effect?
Received on Thu Feb 03 2000 - 09:15:17 CST
