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
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
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
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
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