Re: Oracle deadlock on table with indexes.

From: Volker Hetzer <volker.hetzer_at_ieee.org>
Date: Wed, 21 Jul 2004 12:52:21 +0200
Message-ID: <cdlht6$9ch$1@nntp.fujitsu-siemens.com>

"Paul" <paulz_at_cavendish.co.uk> schrieb im Newsbeitrag news:a4ca837.0407210243.c75eab0_at_posting.google.com...
> The index was actually set by someone other than myself on a different
> site.
> When I comapred the indexes given VC's message, I noted that on one
> index they had set a bitmap. I changed this to a bog-standard index
> (non-unque in my case) and the deadlock dissapeared.
>
> Hope this helps!

Just trying to learn. I had hoped that there was some magic solution allowing you to keep the bitmap indexes.
Would that mean that bitmap indexes aren't good for OLTP systems?

Lots of Greetings!
Volker Received on Wed Jul 21 2004 - 05:52:21 CDT