Subject | RDB$RELATION_CONSTRAINTS |
---|---|
Author | todderamaa |
Post date | 2002-07-05T14:57:31Z |
I am reviewing some stored procedures trying to speed things. These
stored procedures do selects from various tables, some math, but don't
update any tables
I am using Quickdesk to look at the 'Performance Analysis' of these
stored procedures. Many of these procedures show 1322 Non-Indexed
Reads from the table RDB$RELATION_CONSTRAINTS. There are 661 records
in the table RDB$RELATION_CONSTRAINTS.
Why is it reading from this table?
Is there anyway to reduce the number reads it is doing?
Is there anyway to make these reads 'Indexed' reads?
Any help would be appreciated.
Todd
COMPASS Municipal Services Inc.
stored procedures do selects from various tables, some math, but don't
update any tables
I am using Quickdesk to look at the 'Performance Analysis' of these
stored procedures. Many of these procedures show 1322 Non-Indexed
Reads from the table RDB$RELATION_CONSTRAINTS. There are 661 records
in the table RDB$RELATION_CONSTRAINTS.
Why is it reading from this table?
Is there anyway to reduce the number reads it is doing?
Is there anyway to make these reads 'Indexed' reads?
Any help would be appreciated.
Todd
COMPASS Municipal Services Inc.