SQL & PL/SQL

Hi Experts,

The TEMP_CUST table has been inserted with 90 million of records.

I am using the below script to gathering the stats.

EXEC dbms_stats.gather_table_stats('STAGE1_SCHEMA', 'TEMP_CUST',method_opt=>'FOR ALL COLUMNS SIZE AUTO',cascade => TRUE);

The script is running for more than 2 hours.

How to gather the require stats to improve performance of the query.

Please help me.

Thanks in advance.