Hi

I tried this surprsingly index is not being used.I have analyzed my tables..
1* select min(X),max(x) from t1
SQL> /

MIN(X) MAX(X)
---------- ----------
1 10000000

Elapsed: 00:00:26.06

Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=1463 Card=1 Bytes=9)
1 0 SORT (AGGREGATE)
2 1 TABLE ACCESS (FULL) OF 'T1' (Cost=1463 Card=10000000 Byt
es=90000000)





Statistics
----------------------------------------------------------
0 recursive calls
0 db block gets
15208 consistent gets
0 physical reads
0 redo size
238 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

Just wundering if somebody can explain the weird behvaiour.

regards
Hrishy