bitmap index not used

2003-10-29 Thread Josh Collier
Hi, I have a puzzle. A bitmap index on a varchar2(25) column. table has 7131413 rows, of which 7125290 are null for the column in question, the rest of the rows are unique values. There is a histogram on this column, it has 2 buckets. A select statement using this column in the where clause

Re: bitmap index not used

2003-10-29 Thread Mladen Gogala
Which version of the database? Do you have any special setup? Any optimizer parameters on either session or system level? On 10/29/2003 03:09:39 PM, Josh Collier wrote: Hi, I have a puzzle. A bitmap index on a varchar2(25) column. table has 7131413 rows, of which 7125290 are null for the

RE: bitmap index not used

2003-10-29 Thread Josh Collier
version 8.1.7.4 optimizer parameters are default. -Original Message- Sent: Wednesday, October 29, 2003 12:34 PM To: Multiple recipients of list ORACLE-L Which version of the database? Do you have any special setup? Any optimizer parameters on either session or system level? On

Re: bitmap index not used

2003-10-29 Thread Tanel Poder
I'd recommend you to take a dump. A 10053 dump. And see from there. :) Tanel. - Original Message - To: Multiple recipients of list ORACLE-L [EMAIL PROTECTED] Sent: Wednesday, October 29, 2003 10:09 PM Hi, I have a puzzle. A bitmap index on a varchar2(25) column. table has

RE: bitmap index not used

2003-10-29 Thread Khedr, Waleed
Probably the histogram is deciding that. Remove the histogram and see if there is any changes. Waleed -Original Message- Sent: Wednesday, October 29, 2003 3:10 PM To: Multiple recipients of list ORACLE-L Hi, I have a puzzle. A bitmap index on a varchar2(25) column. table has 7131413