thanks for answer, paul.
i have 660 reads from rdb$relation_constraints
on any select to whatever table.
i'm just curious about that.

> -----Original Message-----
> From: PUB: Paul Reeves [mailto:paul@...]
> Sent: Jueves, 01 de Agosto de 2002 03:24
> To: ib-support@yahoogroups.com
> Subject: Re: [ib-support] non-indexed reads
>
>
> PODESTA Mariano APRE wrote:
> > hi,
> > anybody knows why "Performance Analysis" shows
> > too many "non-indexed reads" on table rdb$relation_constraints
> > when you run a 'select' query?
> >
>
> What is 'too many'?
>
> 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
>
>
>
> ------------------------ Yahoo! Groups Sponsor
> ---------------------~-->
> Will You Find True Love?
> Will You Meet the One?
> Free Love Reading by phone!
> http://us.click.yahoo.com/7dY7FD/R_ZEAA/Ey.GAA/67folB/TM
> --------------------------------------------------------------
> -------~->
>
> To unsubscribe from this group, send an email to:
> ib-support-unsubscribe@egroups.com
>
>
>
> Your use of Yahoo! Groups is subject to

http://docs.yahoo.com/info/terms/