Re: SQL statistics

From: Mike Burke <mike.burke_at_dial.pipex.com>
Date: 1996/12/09
Message-ID: <32AC6348.23C2@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 CST