Generate an access path plan for each as well as
checking some tkprof output and you'll see why this is
the case.
hth
connor
--- Daniel Wisser <[EMAIL PROTECTED]>
wrote: > hi!
>
> to speed up queries i have created a bitmap index on
> a column
> that contains 2 chars as a maximum. to my surpri
Hope you are using the CBO and not the RBO. If yu use a Bitmap Index then
the Optimizer will use a CBO and if the stats are not proper then u may not
get a Proper Result.
HTH
Best Regards,
Ganesh R
Tel : +971 (4) 397 3337 Ext 420
Fax : +971 (4) 397 6262
HP : +971 (50) 745 6019
===