To enhance performance, regularly update your database
statistics. See your database platform documentation for procedures.
DBMS_STATS package
The DBMS_STATS package in Oracle optimizes statistics on your database. The system benefits from cost-based optimization because it builds many queries dynamically, depending on user input.
SQL server update statistics
Perform the update statistics procedure to ensure that
selectivity factors are updated when there are significant changes
to an index.