Re: Locks on Bitmap Indexes

Hi

thank you for your answer. After consulting further documentation I see the problem with bitmap indexes.
But perhaps you can tell something about the second part of my question. My application can live with the circumstance that big parts of the table are locked because inserts and updates are performed only by very few users. The table which is indexed has about 250.000 rows with 15 distinct key values. Using B-tree indexes shows significant loss of query performance. I would like to check for an index lock on a specific value in order to inform the user about the situation.

Do you have an idea ?

Bye

Stephan Voigt Received on Sat Nov 21 1998 - 03:30:06 CST