RE: Definition

 3. SQL that is useless
Regards, 

Stephane Faroult 

RoughSea Ltd 
http://www.roughsea.com 


On Fri, 3 Dec 2004 05:22 , 'Reidy, Ron' <Ron.Reidy@xxxxxxxxxxxxxxxxxx> sent:

1. SQL that is wrong
2. SQL that is inefficient

--
Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----
From: oracle-l-bounce@xxxxxxxxxxxxx[1]
[oracle-l-bounce@xxxxxxxxxxxxx[2]','','','')">oracle-l
-bounce@xxxxxxxxxxxxx[3][]On Behalf Of Fahd Mirza
Sent: Friday, December 03, 2004 4:28 AM
To: Active DBA
Subject: Definition


Hi,=20
What would be the definition of a poorly written SQL?
-sql, with wrong join order
-sql, which uses dual =20
- sql, having no bind variables etc etc.
regards,
Fahd
--
http://www.freelists.org/webpage/oracle-l[4]

This electronic message transmission is a PRIVATE communication which =
contains
information which may be confidential or privileged. The information is =
intended=20
to be for the use of the individual or entity named above. If you are =
not the=20
intended recipient, please be aware that any disclosure, copying, =
distribution=20
or use of the contents of this information is prohibited. Please notify =
the
sender of the delivery error by replying to this message, or notify us =
by
telephone (877-633-2436, ext. 0), and then delete it from your system.

--
http://www.freelists.org/webpage/oracle-l[5]



--- Links ---
   1 javascript:parent.opencompose('oracle-l-bounce@xxxxxxxxxxxxx','','','')
   2 javascript:parent.opencompose('<a href=
   3 javascript:parent.opencompose('oracle-l-bounce@xxxxxxxxxxxxx','','','')
   4 
modules/refer.pl?redirect=http%3A%2F%2Fwww.freelists.org%2Fwebpage%2Foracle-l
   5 
modules/refer.pl?redirect=http%3A%2F%2Fwww.freelists.org%2Fwebpage%2Foracle-l
--
http://www.freelists.org/webpage/oracle-l

Other related posts: