Re: Data Access Time

From: Keith Boulton <boulkenospam_at_globalnet.co.uk>
Date: 1998/04/05
Message-ID: <35274f54.3944171@read.news.global.net.uk>#1/1

On Thu, 02 Apr 1998 10:33:21 -0600, Chen Wei Kian <weikian_at_usl.edu> wrote:

>Does anyone know if it is possible to check whcih block of data does
>a given query accessed to get the result ? What I am trying to do is
>to count how many block of data has to be accessed for a given query
>to obtain the result. The purpose of doing so is to compare the time
>required for 2 queries to obtain the result. Do you know if there is
>any other alternative way that allow me to so ?
>Wei Kian Chen

If using sql*plus, you can use SET AUTOTRACE ON Received on Sun Apr 05 1998 - 00:00:00 CST