"Paul Brewer" <paul_at_paul.brewers.org.uk> wrote in message
news:3e00ec97_1_at_mk-nntp-1.news.uk.worldonline.com...
> In other words, don't use them unless this is a DW being rebuilt
overnight?
I very nearly posted a similar reply to Jonathans (though probably
inaccurate) with the comment "bitmap indices are really a datawarehouse
construct, but can also be useful for static tables of relatively low
cardinality", but the Outlook express crashed when adding a signature a too
common occurrence. My point bitmap indices can be use ful in OLTP
environments the requirement is a (relatively) static table not one with
zero DML.
--
Niall Litchfield
Oracle DBA
Audit Commission UK
*****************************************
Please include version and platform
and SQL where applicable
It makes life easier and increases the
likelihood of a good answer
******************************************
Received on Thu Dec 19 2002 - 15:22:22 CST
