By David Gibbs – In order for Oracle to use the Cost Based Optimizer (CBO) effectively, schema objects must have current statistics. Instead of analyzing all user objects regularly, which is costly, in 8i and above you can have Oracle monitor table usage.
Read More - Register for Free Membership
SQL Server, Azure SQL Database, Amazon RDS & AWS, Oracle and IBM Help