Well... now I get a different result from yesterday...

SQL> alter session disable parallel query;

Session altered.

Elapsed: 00:00:00.04
SQL> select count(*) from crp_sio;


COUNT(*)
----------
658768

Elapsed: 00:00:07.05

Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=599 Card=1)
1 0 SORT (AGGREGATE)
2 1 TABLE ACCESS (FULL) OF 'CRP_SIO' (Cost=599 Card=691601)

SQL> alter session force parallel query;

Session altered.

Elapsed: 00:00:00.01

SQL> select count(*) from crp_sio;

COUNT(*)
----------
658768

Elapsed: 00:00:04.26

Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=67 Card=1)
1 0 SORT (AGGREGATE)
2 1 SORT* (AGGREGATE) :Q19000
3 2 TABLE ACCESS* (FULL) OF 'CRP_SIO' (Cost=67 Card=691601 :Q19000
)
2 PARALLEL_TO_SERIAL SELECT /*+ PIV_SSF */ SYS_OP_MSR(COUNT(*)) F
ROM (SELECT /*+ NO_EXPAND ROWID(A2)

3 PARALLEL_COMBINED_WITH_PARENT

[Edited by grjohnson on 10-03-2002 at 12:14 AM]