Re: Bitmap index - how many rows get locked

2001-10-01 Thread Jonathan Lewis
There is currently no realistic way you can discover how many rows are locked when you change the bitmap-indexed column of a single row. The number is dependent on blocksize, distribution of data, and the coincidental overlap of the FROM and TO bitmap chunks. The answer could vary from a

Bitmap index - how many rows get locked

2001-09-30 Thread Reardon, Bruce (CALBBAY)
Hi, Is it possible to find out the actual number of locked rows? For example: SQL desc test Name Null?Type - F NUMBER(38) SQL select * from test; F -- 1 1 1