Whenever we have some performance issues. First thing we will do is run this command on all the tables in our schema
so all the statistics are up to date.
ANALYZE TABLE <TABLE_NAME> COMPUTE STATISTICS;
We have Oracle 11g R2 database.
1) Is the command what we are using above is pretty old ? Is there a newer one ?
2) What command can we use as SYS user to ANALYZE an entire schema ?