Are indices on system tables after a metadata backup lost or is this only
for user-defined triggers on system tables?

Thx
Thomas

> -----Original Message-----
> From: Alexander V.Nevsky [mailto:alex_vnru@...]
> Sent: Friday, June 22, 2001 11:33 AM
> To: ib-support@yahoogroups.com
> Subject: [ib-support] Re: Non-indexed reads on system tables
>
>
> Hi, people interested in topic. In databases with many referential
> constraints
>
> (CREATE INDEX RDB$INDICES_IDX1 ON
> RDB$INDICES (RDB$FOREIGN_KEY);)
>
> greatly improves prformance on first execution of selects. In my case
> (about 800 ref_constraints, 2000 indices) - 20 times. It's not my
> idea, got from one of Russian newsgroups.
>
> Best regards.
>
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to http://docs.yahoo.com/info/terms/
>
>
>