Re: Database or store to handle 30 Mb/sec and 40,000 inserts/sec

On Sun, 19 Feb 2006 15:02:15 +0000, ianal Vista wrote:

> "Tony Rogerson" <tonyrogerson_at_sqlserverfaq.com> wrote in news:dt976n$j6u$1
> $8300dec7_at_news.demon.co.uk:
>

>> Unless its using bitmap indexes and then its possible.
>> 

Updating a the value that is indexed in bitmap index requires locking the table until the bitmap is rebuild. Hence, Oracle's very clear documentation about not using bitmap indexes in an update environment.

However, since this is in documentation, SS coders will ignore it and then whine about bitmap indexes causing locks when they use them inappropriately.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** Top posting [replies] guarantees I won't respond. ***