|Subject||Re: Very long prepare time|
> index IDX1 for RDB$INDICES RDB$FOREIGN_KEY;
> index IDX2 for RDB$RELATION_CONSTRAINTS
> RDB$RELATION_NAME, RDB$CONSTRAINT_TYPE;
> Note this indices don't survive backup/restore, you should create
> manually each time you restore database. In FB1.5 they are realsystem
> indices RDB$INDEX_42 and RDB$INDEX_43.Ded, you have more than 800 tables -
> Best regards, Alexander V.Nevsky.
I have a database with about 120.
RDB$INDICES ~ 400 records
RDB$RELATION_CONSTRAINTS ~ 700 records
Do you think that this will speed up queries - there are some very