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