Re: SQL query tuning method?

From: Barry Schader <barryaz1_at_home.com>
Date: Wed, 14 Mar 2001 05:22:47 GMT
Message-ID: <HeDr6.25800$Xt3.3970920@news1.rdc1.az.home.com>

Ron,

Oracle offers a pretty good 3-day course on the subject of tuning SQL statements (or at least they did three years ago when I took it). There's quite a bit to it.

Anyway, a quick way to get an execution plan in SQL*Plus is to run UTLXPLAN.SQL as Mirek indicated, then issue this command:

SQL> set autotrace on

Subsequently, after each SQL statement, you will get a listing of the execution plan and some useful statistics.

--Barry

"Ron" <ronyin_at_tpts5.seed.net.tw> wrote in message news:98i2tc$aki_at_netnews.hinet.net...
> does anyone know how to tune a SQL qurey?
>
> Ron
>
>
Received on Tue Mar 13 2001 - 23:22:47 CST