After Work
The best club in Chicago
for Chicago Singles is
Highlife Adventures!
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent beer selection!
|
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 );
|
|
|
|
