Skip to Main Content

SQL & PL/SQL

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

Bitmap index column goes for full table scan

890271Apr 4 2013 — edited Apr 6 2013
Hi all,

Database : 10g R2
OS : Windows xp

my select query is :

SELECT tran_id, city_id, valid_records
FROM transaction_details
WHERE type_id=101;

And the Explain Plan is :

Plan
SELECT STATEMENT ALL_ROWSCost: 29 Bytes: 8,876 Cardinality: 634
1 TABLE ACCESS FULL TABLE TRANSACTION_DETAILS** Cost: 29 Bytes: 8,876 Cardinality: 634


total number of rows in the table = 1800 ;
distinct value of type_ids are 101,102,103

so i created a bit map index on it.

CREATE BITMAP INDEX btmp_typeid ON transaction_details
(type_id)
LOGGING
NOPARALLEL;

after creating the index, the explain plan shows the same. why it goes for full table scan?.

Kindly share ur idea on this.

Edited by: 887268 on Apr 3, 2013 11:01 PM

Edited by: 887268 on Apr 3, 2013 11:02 PM

Comments

Processing
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 4 2013
Added on Apr 4 2013
18 comments
749 views