Re: Strange CBO Behaviour with a Bitmap Index

I suspect you will find that having to go to the index as well as the data to get the information will more than double your I/O (logically, and perhaps physically, depending on whether you are using multiple buffer pools and what else is going on, and especially descending), and probably some other things will be going on so you will find the CBO was right to pick the FTS to begin with.

But please tell us what you find out.

jg

--
@home.com is bogus.
"While I was being injected with hormones that could make a
tyrannosaurus give birth to a foldout couch, my oldest sister Sandra
Meyer, who was an advanced breast cancer patient, was having monthly
chemotherapy treatments." -  RIP Wendy Wasserstein