Ramin Hossaini

Update statistics on all objects in a database

Feb
20

This helps Oracle choose the best execution plan for queries:

BEGIN
dbms_stats.gather_database_stats(options=> 'GATHER AUTO');
END;
/

Leave a Reply

Your email address will not be published. Required fields are marked *