After Work
The best club in Chicago
for Chicago Singles is
Highlife Adventures!
Are you looking for a
Jersey Girl T-Shirt
?
Kyoto Sushi
in Chicago, on Lincoln Ave.
Moody's Pub
in Chicago, has great burgers
Skylark
in Chicago, on Halsted .. excellent Friday fish fry!
|
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 );
|
|
|
|
