Bitmap Indexes and
ABotanaNov 24 2003 — edited Nov 30 2003I manage a table with 1 Million rows. Each row have an "status" column with could have only 2 values "OK" or "PEND".
Normally just a few rows (3-5) have in a moment the value "PEND" and immediately change to "OK" using a trigger in this table.
The question is that when the process try to access the rows with value "PEND" with a single direct query in the column status it delays near 15 minutes and access using a full scan.
�There is something about the bitmap indexes I have to consider?
Thanks in advance.
Agustin