Why Is Update Statistics Important To A Database?

1.	Why Is Update Statistics Important To A Database?
Answer» Running update STATISTICS will update the system CATALOG information about the database. This information is USED by the Informix optimizer to calculate costs and execution PLANS for day to day queries. Lack of up-to-date information about data distributions MAY result in severely bad plans.

Answer»

Running update STATISTICS will update the system CATALOG information about the database.
This information is USED by the Informix optimizer to calculate costs and execution PLANS for day to day queries. Lack of up-to-date information about data distributions MAY result in severely bad plans.

Discussion