Pages accessed in an Ingres query.

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Damien Owen - 03 Nov 2004 13:52 GMT

Hi,

Does anyone know of a trace point that would give the number of pages
used by a given query?

Thanks

Reply to this Message

Roy Hann - 05 Nov 2004 09:53 GMT

> Hi,
>
> Does anyone know of a trace point that would give the number of pages
> used by a given query?

Trace point QE90 is the nearest thing I can think of. But I suspect that is
not what you are looking for. What are you trying to discover?

Roy Hann (rhann at rationalcommerce dot com)
Rational Commerce Ltd.
www.rationalcommerce.com
"Ingres development, tuning, and training experts"

Reply to this Message

Damien Owen - 06 Nov 2004 15:08 GMT

> > Hi,
> >
[quoted text clipped - 8 lines]
> www.rationalcommerce.com
> "Ingres development, tuning, and training experts"

I want to know the number of pages a query will use to help predict
whether the query will fill the transaction log file.

Reply to this Message