|Subject||Re: [firebird-support] Recreate indexes|
> and so I can't recreate all index?You have to skip those underlaying indexes, which are part of a constraint.
> Or I have only to skyp primary key?
For example, the following system table query gives you a list of
indexes, which can be deactivated/activated:
(i.rdb$system_flag = 0 or i.rdb$system_flag is null)
and not exists (
rc.rdb$index_name = i.rdb$index_name
> But If I need to recreate PK what I have to do?You have to drop the constraint and re-create it afterwards.
The whole thing is different, if we are talking about the SET STATISTICS
statement. This statement can be executed against any index. See
LogManager Series - Logging/Auditing Suites supporting
InterBase, Firebird, Advantage Database, MS SQL Server and