compute statistics advice request
Posted on 2005-05-01
When running a java-based application that calls a base class to insert records and select others, the select statements sometimes seem to take an awful long time. Well, I added an "ANALYZE TABLE table COMPUTE STATISTICS" statement that is executed before each call to this base class. This seems to speed things up quite a bit. The trouble is, I'm fairly new to Oracle, and I want to make sure I understand all of the ramifications of such an approach. Is my approach "safe"? Is there a better approach?