Re: Oracle SQL script needs finetuning in TOAD

From: ianal Vista <ianal_vista_at_hotmail.com>
Date: Wed, 31 May 2006 01:02:35 GMT
Message-ID: <Xns97D3B7A0DB25ianalvistahotmailcom@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 Received on Tue May 30 2006 - 20:02:35 CDT