Re: Oracle SQL script needs finetuning in TOAD

"ianal Vista" <ianal_vista_at_hotmail.com> wrote in message news:Xns97D3B7A0DB25ianalvistahotmailcom_at_70.169.32.36...
: email.bernie_at_gmail.com wrote in news:1149034932.698746.274280
: @y43g2000cwc.googlegroups.com:
:
: > Hi Frank,
: > My guess is, maybe its using too many functions, and/or there's too
: > many sub select queries to go through.
: > There's only a few hundred records in this table at the most.
: > What do you mean by the execution plan?
: > I just paste this query into a table called REPORTS, and into a field
: > called SQL_REP, and the Web site does the rest.
: >
:
: Those who live by the GUI, die by the GUI.
:
: If you get desparate, you should consider learning how to use SQL*Plus

you can't tune SQL without knowing what an execution plan is -- do a little self study (googling and tahiti.oracle.com will help) to understand basic SQL statement tuning, then use either SQL*Plus SET AUTOTRACE ON or the Explan Plan tab in TOAD to review the execution plan. when you get to that point, post your plan for specific assistance

++ mcs Received on Wed May 31 2006 - 06:00:26 CDT