Subject Non-indexed reads on system tables
Author Rob Schuff
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?



Robert Schuff Bull Run Software
rob@... Portland, OR USA