SQL> analyze table t compute statistics for table for all indexes for ALL INDEXED COLUMNS size 254;


SQL> select * from t where object_name = 'SMITH';

Execution Plan
----------------------------------------------------------------------------------------------

   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=2 Card=207 Bytes=4968)
   1    0   INDEX (RANGE SCAN) OF 'T_IDX' (NON-UNIQUE) (Cost=2 Card=207 Bytes=4968)

SQL> select * from t where object_name = 'FOO';


Execution Plan
----------------------------------------------------------------------------------------------
   0      SELECT STATEMENT Optimizer=CHOOSE (Cost=1 Card=2 Bytes=48)
   1    0   INDEX (RANGE SCAN) OF 'T_IDX' (NON-UNIQUE) (Cost=1 Card=2 Bytes=48)