Re: ANALYZE %

jon glickman wrote:
>
> Does anybody understand why I am seeing no change in the ALL_TABLES,
> DBA_TABLES... for the analyze sample 70 percent option of
> when I query these tables for small databases.
>
> set echo off pagesize 0 feedback off verify off
>
> accept vowner prompt 'Analyze tables OWNED by: '
> accept vname prompt 'Analyze all tables with the NAME: '
>
> spool analtbl.drv
>
> select 'analyze table '||owner||'.'||table_name||' estimate statistics
> sample 80 percent;'
> from sys.dba_tables
> where table_name like upper('&vname') and owner like upper ('&vowner');
>
> spool off
>
> set echo on pagesize 24 feedback on verify off

  Have you executed the statement ANALYZE ?

---
Name   : Lun Wing San
Title  : Oracle Application Developer of Hong Kong Productivity Council
         Oracle Database Administrator and System Administrator of QRC
Phone  : (852)27885841