Subject | RE: [ib-support] How does one deactivate indicies during a massive update operation? |
---|---|
Author | Ann W. Harrison |
Post date | 2002-01-03T22:56:17Z |
At 11:19 PM 1/3/2002 +0100, Kaputnik wrote:
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.
>a select similar to this one:(RDB$SYSTEM_FLAG = 0 or RDB$SYSTEM_FLAG IS NULL)
>
>select RDB$INDEX_NAME from RDB$INDICES
>...
> and (not RDB$INDEX_NAME like 'RDB$%')
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.