Friday, 4 August 2017

Gather Table Stats with CASCADE TRUE option

Gather table stats with CASCADE TRUE option.
VIJ.VIJ_ITEMS_D

Connect Using system user

->Verify last_analyzed
select * from dba_tables where table_name='VIJ_ITEMS_D'
From TOAD-->

BEGIN
 dbms_stats.gather_table_stats(ownname=> 'VIJ', tabname=> 'VIJ_ITEMS_D', cascade=> TRUE);
END;

>Verify last_analyzed
select * from dba_tables where table_name='VIJ_ITEMS_D'

No comments:

Post a Comment

SQL Shared Area - BIND MISMATCH