| Subject | How to improve RDB$RELATION_CONSTRAINTS readings? |
|---|---|
| Author | mmenaz |
| Post date | 2002-02-09T00:09:57Z |
Firebird RC2
Hi, I've a query that selects also from two stored procedure (a somewhat complex setup, too mutch to show you here ;).
Looking at it's performance analysis, I've seen few reading (data in tables are really few, I'm still developing the application) most of them indexed, but a huge number of unindexed reading to RDB$RELATION_CONSTRAINTS (588 for a 10 rows result dataset).
What does it mean? How I can have better performance on RDB$RELATION_CONSTRAINTS reading? (I mean, can I add indexes?)
Thanks for the attention
Marco Menardi
Btw, I don't give you more details as far as I think it's a general question regarding know SQL/IB way of working, so you don't need more
Hi, I've a query that selects also from two stored procedure (a somewhat complex setup, too mutch to show you here ;).
Looking at it's performance analysis, I've seen few reading (data in tables are really few, I'm still developing the application) most of them indexed, but a huge number of unindexed reading to RDB$RELATION_CONSTRAINTS (588 for a 10 rows result dataset).
What does it mean? How I can have better performance on RDB$RELATION_CONSTRAINTS reading? (I mean, can I add indexes?)
Thanks for the attention
Marco Menardi
Btw, I don't give you more details as far as I think it's a general question regarding know SQL/IB way of working, so you don't need more