Murali:
The only issue that I know of is in Oracle that the SQL statement must be
less than 64K. I've written 3-page SQL statements that returned in the
sub-0.1 second range.
However, from a human standpoint, the longer the SQL is, the harder it is
for a new developer to pick up and tune/debug/tweak/etc. In general, I try
to keep my SQL to under 1/2 page. But I DO NOT sacrifice readability in
order to keep my SQL Under 1/2 page. Most of the time, when I'm asked to
tune or debug a SQL statement, my reformatted, revised SQL winds up being
longer than the original -- but much easier for a human to read --
reformatting it makes it easier for me to tune or correct.
HTH
Caver
-Original Message-
Sent: Wednesday, November 28, 2001 12:22 PM
To: Multiple recipients of list ORACLE-L
Are there any implications on how long the SQL statement is? The current SQL
statements that I am inheritting, is really long. tons of embedded sub
queries etc.
My first question is are there any known issues with haveing very long SQL
statements and if yes what has been a good length other than the fact that
it may depend on your SGA.
Thanks
Murali
_
Get your FREE download of MSN Explorer at http://explorer.msn.com/intl.asp
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Murali Vallath
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Toepke, Kevin M
INET: [EMAIL PROTECTED]
Fat City Network Services-- (858) 538-5051 FAX: (858) 538-5051
San Diego, California-- Public Internet access / Mailing Lists
To REMOVE yourself from this mailing list, send an E-Mail message
to: [EMAIL PROTECTED] (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
