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 gene

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

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 10/29/20

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 ha

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 r