Subject | Re: [ib-support] non-indexed reads |
---|---|
Author | Paul Reeves |
Post date | 2002-08-01T06:23:58Z |
PODESTA Mariano APRE wrote:
Don't forget that all the system tables are usually read from memory,
and for small tables you wont see any performance gain from indexed reads.
Paul
--
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase
> hi,What is 'too many'?
> anybody knows why "Performance Analysis" shows
> too many "non-indexed reads" on table rdb$relation_constraints
> when you run a 'select' query?
>
Don't forget that all the system tables are usually read from memory,
and for small tables you wont see any performance gain from indexed reads.
Paul
--
Paul Reeves
http://www.ibphoenix.com
Supporting users of Firebird and InterBase