dbms_utility.analyze_schema('schema_name','compute') after impdp
When we request a data refresh in our TEST database, the company that manages our Oracle databases performs an impdp followed by an analyze. I keep reading that the impdp process performs the analyze as part of the datapump import. Here's my question:
Does running a datapump import using default parameters compute schema statistics? For example, is it sufficient to run impdp system@database directory=xyz dumpfile=abc.dmp logfile=abc_imp.log schema=AAA, or do I need to follow up with EXECUTE DBMS_UTILITY.ANALYZE_SCHEMA(('AAA','COMPUTE'); to generate statistics necessary for an efficient optimizer?
Thanks in advance!