Subject RE: [ib-support] How does one deactivate indicies during a massive update operation?
Author Ann W. Harrison
At 11:19 PM 1/3/2002 +0100, Kaputnik wrote:
>a select similar to this one:
>
>select RDB$INDEX_NAME from RDB$INDICES
>...
> and (not RDB$INDEX_NAME like 'RDB$%')

(RDB$SYSTEM_FLAG = 0 or RDB$SYSTEM_FLAG IS NULL)

is a better way to do that. The name is an artifact.
The system flag is definitive.


Regards,

Ann
www.ibphoenix.com
We have answers.