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