Re: Definition

From: Terry Sutton <terrysutton_at_usa.net>
Date: Fri, 3 Dec 2004 08:40:44 -0800
Message-ID: <037d01c4d957$4e944ae0$6501a8c0@TerrySutton>

SQL which doesn't use bind variables is not necessarily bad or poorly written. If you always use the same or a limited number of literals in a query and you have histograms on the table(s), you don't want to use bind variables.

I'm not sure "wrong" join order is necessarily "poorly written". Are you always using "ordered" hints or the RBO.

I would add to your list "SQL which doesn't need to be run". :-)

--Terry

Original Message ----- From: "Fahd Mirza" <fahd-m_at_aero.com.pk> To: "Active DBA" <oracle-l_at_freelists.org> Sent: Friday, December 03, 2004 3:27 AM Subject: Definition

Hi,
What would be the definition of a poorly written SQL?
-sql, with wrong join order
-sql, which uses dual

sql, having no bind variables etc etc. regards, Fahd
--
http://www.freelists.org/webpage/oracle-l

--

http://www.freelists.org/webpage/oracle-l Received on Fri Dec 03 2004 - 10:43:59 CST