Kindly guide me for the query for gathering all the statistics of indexes in one schema.
I have given the following query but it is giving error.
exec DBMS.STATS.GATHER_INDEX_STATS('name of the index')
it is giving me error the DBMS.STATS must be declared.
however when i tried to analyze all my tables of whole schema by similar query.it worked nicely.
Kindly guide me to suitable solution