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

morgalr

That is a lot of code to go through, so I am not.

Let me ask you this:  I see you have a portion that is marked as recursive, do you recursively call the loading of the images?  If you do therein is your problem.

RuGI:.

Have you tried to define your Layout at  level of the class as static attribute?
You only require one.


Each time you use a BufferedImage, after painting the image invokes flush


picture.flush();

picture = null;

---

RuGI

Max8090-JavaNet

Thanx for the answer.

Can you tell me, which lines are recursive?

It was not my intent to do a recursive call. If so, this could maybe the problem.

Max8090-JavaNet

Yes, but didn't help.

Max8090-JavaNet

The problem is solved. I don't use the class OverlayLayout anymore. The layout looks quite different, but now it works.

1 - 5
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
794 views