If you don't analyze tables the cost based optimizer to guess what the best optimization is for your queries assuming that there is no data , the CBO will guess poorly in that case. In general, you will see dramatic improvement after analysis if you have never analyzed.
This is in the case of CBO.




Reply With Quote