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