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_at_arraybiopharma.com> sent:

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

--

Ron Reidy
Lead DBA
Array BioPharma, Inc.

-----Original Message-----

From: oracle-l-bounce_at_freelists.org[1]
[oracle-l-bounce_at_freelists.org[2]','','','')">oracle-l
-bounce_at_freelists.org[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_at_freelists.org','','','') 2 javascript:parent.opencompose('<a href= 3 javascript:parent.opencompose('oracle-l-bounce_at_freelists.org','','','') 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