RE: bitmap indexes and rule based optimizer

2001-09-12 Thread Walthour, Jon (GEAE, Compaq)
Alex: No, the rbo does not support bitmap indexes or any other Oracle8 or greater feature (such as partitioning, etc.). To use these features, you must set optimizer_mode to CHOOSE, FIRST_ROWS or ALL_ROWS, which will invoke the cbo. Jon Walthour -Original Message- Sent: Wednesday,

RE: bitmap indexes and rule based optimizer

2001-09-12 Thread Vadim Gorbounov
No, CBO only HTH Vadim Gorbounov Oracle DBA -Original Message- Sent: Wednesday, September 12, 2001 1:05 PM To: Multiple recipients of list ORACLE-L Anybody knows whether rule based optimizer can use bitmap indexes? Alex Hillman -- Please see the official ORACLE-L FAQ:

RE: bitmap indexes and rule based optimizer

2001-09-12 Thread Hillman, Alex
Thanks. However bitmap indexes are 7.3+ feature - why I asked. Alex Hillman -Original Message- Sent: Wednesday, September 12, 2001 1:50 PM To: Multiple recipients of list ORACLE-L Alex: No, the rbo does not support bitmap indexes or any other Oracle8 or greater feature (such as

RE: bitmap indexes and rule based optimizer

2001-09-12 Thread Prasada . Gunda1
: Sent by: Subject: RE: bitmap indexes and rule based optimizer [EMAIL PROTECTED

RE: bitmap indexes and rule based optimizer

2001-09-12 Thread Walthour, Jon (GEAE, Compaq)
True. Whoops. Jon Walthour -Original Message- Sent: Wednesday, September 12, 2001 4:15 PM To: Multiple recipients of list ORACLE-L Thanks. However bitmap indexes are 7.3+ feature - why I asked. Alex Hillman -Original Message- Sent: Wednesday, September 12, 2001 1:50 PM To: