Skip to Main Content
Forums

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

Jim Smith

SQL Developer doesn't put anything in the registry.
From your reference to SID, I assume you are looking for a database. SQL Developer is only a client tool, it doesn't come with a database.
You will need to download and install the database software as well. The easiest thing to do is to download express edition
Oracle Database Express Edition (XE) Downloads (0 Bytes)

What Jim said, we don't have an installer, we don't put anything into the registry.
I think we'll check the registry for an Oracle Client/HOME, but we write all of our application settings to your AppData folder, under Roaming Profiles.

1 - 2
Locked Post
New comments cannot be posted to this locked post.

Post Details

Locked on May 4 2013
Added on Apr 4 2013
#column, #for, #index, #table
18 comments
764 views