Normal index created , but still NOT USED




SQL> create index MAGTAC.SSFRACC_NAME_ACCNTTYPE_BIDX ON MAGTAC.SSRFACC_NAME (accnt_type)
2 tablespace indx;

Index created.

SQL> analyze table ssrfacc_name compute statistics;

Table analyzed.

SQL> analyze table ssrfacc_name compute statistics for all indexes;

Table analyzed.

SQL> set autotrace trace
SQL> ed
Wrote file afiedt.buf

1 SELECT (anal_a2), a2_name
2 FROM
3 ssrfacc_name a
4* WHERE accnt_type ='T'
SQL> /

19 rows selected.


Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=1917 Card=36087 Byte
s=1515654)

1 0 TABLE ACCESS (FULL) OF 'SSRFACC_NAME' (Cost=1917 Card=3608
7 Bytes=1515654)





Statistics
----------------------------------------------------------
143 recursive calls
5 db block gets
12703 consistent gets
11764 physical reads
0 redo size
1120 bytes sent via SQL*Net to client
579 bytes received via SQL*Net from client
5 SQL*Net roundtrips to/from client
2 sorts (memory)
0 sorts (disk)
19 rows processed

SQL>