Subject | Non-indexed reads on system tables |
---|---|
Author | Rob Schuff |
Post date | 2001-06-14T17:55:09Z |
Hi Folks,
In using IBExpert, one can get a performance analysis of a stored procedure
execution. I have a SP that performs serveral selects and then outputs the
results as parameters. In l;ooking at the performance anaylsis there
several non-indexed reads on RDB$INDICES and RDB$RELATION_CONSTRAINTS.
I have searched the archives unsuccessfully to find out the full story and
what (if anything) one can/should do to remedy that issue.
anyone know?
thanks
Rob
---------------------------------------------------------------------
Robert Schuff Bull Run Software
rob@... Portland, OR USA
---------------------------------------------------------------------
In using IBExpert, one can get a performance analysis of a stored procedure
execution. I have a SP that performs serveral selects and then outputs the
results as parameters. In l;ooking at the performance anaylsis there
several non-indexed reads on RDB$INDICES and RDB$RELATION_CONSTRAINTS.
I have searched the archives unsuccessfully to find out the full story and
what (if anything) one can/should do to remedy that issue.
anyone know?
thanks
Rob
---------------------------------------------------------------------
Robert Schuff Bull Run Software
rob@... Portland, OR USA
---------------------------------------------------------------------