Subject Question about ALTER INDEX
Author Christian Kaufmann

I have some questions about indexes in FB 1.5.2:

- How can I check with an SQL statement if an index is active or inactive?
- If I call ALTER INDEX name ACTIVE, will the index be rebuilt in any
case or only if it was inactive before?
- Is there a way to have a filtered index? This means only records that
meet a certain condition will be in the index?
- Is there a way to "freeze" the index ? I mean that the index with a
current state is available for select statements, but new inserts are
done without altering the index.

cu Christian