Re: SQL statistics
From: Mike Burke <mike.burke_at_dial.pipex.com>
Date: 1996/12/09
Message-ID: <32AC6348.23C2_at_dial.pipex.com>#1/1
Date: 1996/12/09
Message-ID: <32AC6348.23C2_at_dial.pipex.com>#1/1
> Zernan Martinez wrote:
> >
> > Does anybody know how to display statistics on a SQL request?
> > I would like to know how Oracle processed my query any hopefully be
> > able to optimize my request.
If it's available on your release you can try this from SQL*Plus :
SQL> set autotrace on
This will produce explain plans for your queries (you may have to run a script to create the explain plan table first though).
Mike Received on Mon Dec 09 1996 - 00:00:00 CET