ANALYZE %

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

@analtbl.drv

Any suggestions?

                                        jglickma_at_lynx.neu.edu Received on Sat Dec 21 1996 - 00:00:00 CST