Custom Search
www.rocket99.com : Technical Guides Sybase Oracle UNIX Javascript


Technical Guides
Sybase
Oracle
UNIX
Javascript




Of Interest

Business Intelligence and Analytics



Oracle Training





Oracle » DDL » DBA » Performance

Analyze and Gather Statistics
Oracle 8, 9, and 10g
     






-- for entire schema

exec dbms_stats.gather_schema_stats ( OWNNAME => 'PEOPLESOFT',
METHOD_OPT => 'FOR ALL INDEXED COLUMNS SIZE 1',
ESTIMATE_PERCENT => 25,
CASCADE => TRUE,
GRANULARITY => 'ALL' );


-- for single table

exec dbms_stats.gather_table_stats(
METHOD_OPT => 'FOR ALL INDEXED COLUMNS SIZE 1',
TABNAME => 'accounts',
estimate_percent=>15,
degree=>1 );











Oracle : Related Topics

Oracle : DDL : Creating a table - Part II
Oracle : DDL : Moving a table
Oracle : DDL : Renaming a table

Sybase Web Site
Sybase iAnywhere Mobile Web Site
Oracle Enterprise Web Site



Get the latest Rocket99 news and tech tips via






Site Index About this Guide to Sybase, Oracle, and UNIX Contact Us Advertise on this site




Copyright © 2016 Stoltenbar Inc All Rights Reserved.