Re: buffer gets per execution

From: http://www.webyourcompany.com <xzhang88_at_hotmail.com>
Date: 5 Jun 2003 20:15:03 -0700
Message-ID: <2f50b64b.0306051915.2de00fdc@posting.google.com>

For the SQL statement how much Logic I/o it takes to execute once? Buffer gets=Logical I/O=(query+current)

As far far as how to tell if the buffer gets/execution is too high or reasonable, you need to use your judgement based on your knowledge of the data.

two targets here:
One is to parse once but execute many times for the same sql--reduce parse
Another is to use as less buffer gets as possible to achieve the task of that statement--by rewriting the sql to answer the same question but more efficiently, changing the data storage etc.

HTH,
http://www.webyourcompany.com

i_rahim_at_hotmail.com (Imran Rahim) wrote in message news:<e7519cfe.0306040851.1ab0ac24_at_posting.google.com>...
> Hi
>
> When measuring buffer gets per execution, how do you decide whether
> the hits are too high or just right ?
Received on Thu Jun 05 2003 - 22:15:03 CDT