Hi

I have a one million row table.Here is what the results are

SQL> select max(x) from t1;

MAX(X)
----------
10000000

Elapsed: 00:00:09.08

Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=1463 Card=1 Bytes=9)
1 0 SORT (AGGREGATE)
2 1 INDEX (FULL SCAN (MIN/MAX)) OF 'T1_IDX' (NON-UNIQUE) (Co
st=1463 Card=10000000 Bytes=90000000)





Statistics
----------------------------------------------------------
22 recursive calls
0 db block gets
5 consistent gets
0 physical reads
0 redo size
208 bytes sent via SQL*Net to client
276 bytes received via SQL*Net from client
2 SQL*Net roundtrips to/from client
0 sorts (memory)
0 sorts (disk)
1 rows processed

I have a modest server with 2Gb Ram and 2 CPU 440Mhz machine.

regards
Hrishy