Subject | Repost: How to improve RDB$RELATION_CONSTRAINTS readings? |
---|---|
Author | mmenaz |
Post date | 2002-02-10T15:05:07Z |
Sorry if I repost, but I do need to be sure I'm not doing something really wrong with my DB design (I don't want to discover it after my customers have inserted 10,000 rows!)
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? Indexing what?)
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. If I'm wrong, I will try to provide some simple sample.
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? Indexing what?)
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. If I'm wrong, I will try to provide some simple sample.