Re: statement tuning

From: John Edward Scott <admin_at_NOdaedalus-soln.demon.co.ukSPAM>
Date: Sat, 9 Jun 2001 01:02:33 +0100
Message-ID: <992044830.25425.0.nnrp-01.d4e495f5@news.demon.co.uk>

You could use explain plans (see the help for more info). Alternatively set SQL_TRACE to true (either in the session or the system if you want to monitor everything *briefly*), then use TKPROF to analyze the results.

John

"Thomas Porschberg" <mail_at_porschberg.de> wrote in message news:m31yovqbzy.fsf_at_redrat.quark.de...
> I'am looking for a tool under linux that helps to optimize SQL
> statements?
> thx for every kind of hint
> --
> Have a look at: http://www.porschberg.de
Received on Fri Jun 08 2001 - 19:02:33 CDT