Why do you assume that anybody reading this theead will be too stupid to notice that I was commenting on the following exchange, and that you've tried to avoid the issue:you abuse him for asking questions.But when Daniel Morgan asks for more information
Morgan wrote: "You are asking the wrong question for
the wrong reason."
1 - It's not a question, genius
2 - Morgan was the one who was abusive.
That's none of your business. It has NOTHING to doWhat business problem are you facing and in what version?
with his question about bitmaps.
I'll take a guess that you have an internal rationalisation mechanism that says something like: "if I don't make a declarative statement, it doesn't matter what I say, it doesn't count as a lie.""both ways Burleson"so from now on I think I'll just have to call you
You have called me a lot worse! Do you really think
that your "friends" don't share your e-mails with me?
Just to compare notes, I've see update on tables withCan you supply any information about the typical types of activity where you see this happen ?
three bitmap indexes take 20 wall-clock seconds
That's none of your business. It has NOTHING to do with his question about bitmaps.What business problem are you facing and in what version?
And here I have, eh, proved that it is faster with the hint.
select count(*) from item_country_config_t; COUNT(*) ---------- 6609172 Elapsed: 00:00:04.15
select /*+ fast_mode(true)*/ count(*) from item_country_config_t; COUNT(*) ---------- 6609172 Elapsed: 00:00:01.12