| Subject | Re: Non-indexed reads on system tables |
|---|---|
| Author | Alexander V.Nevsky |
| Post date | 2001-06-22T09:33:26Z |
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.
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.