--- In ib-support@y..., "Krzysztof Dyczkowski" <k.dyczkowski@a...>
wrote:

> Adding index on field RDB$RELATION_NAME can improve performance of

query?

> I'm asking because performance analysis reports on every query

non-indexed

> reads from this table.

Krzysztof, it depends on amount of tables in your database. If this
amount is small, index can decrease performance, but in complex
databases it should significantly increase it. I can't say exactly
what is "small", you can check it on your database. But my own
practice shows that for databases of common complexity indexes by
RDB$FOREIGN_KEY on RDB$INDICES and by RDB$RELATION_NAME on
RDB$RELATION_CONSTRAINTS are very useful.
If you want to implement additional indexes on system tables, you
should know that you must re-create them after each backup/restore,
gbak don't create them.

Best regards, Alexander V.Nevsky.