From oracle-l-bounce@freelists.org Sun Dec 5 20:54:54 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id iB62ssk19749 for ; Sun, 5 Dec 2004 20:54:54 -0600 X-ClientAddr: 206.53.239.180 Received: from turing.freelists.org (freelists-180.iquest.net [206.53.239.180]) by air189.startdedicated.com (8.11.6/8.11.6) with ESMTP id iB62ssu19744 for ; Sun, 5 Dec 2004 20:54:54 -0600 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id E07A872C09C; Sun, 5 Dec 2004 22:01:17 -0500 (EST) Received: from turing.freelists.org ([127.0.0.1]) by localhost (turing [127.0.0.1]) (amavisd-new, port 10024) with ESMTP id 32447-45; Sun, 5 Dec 2004 22:01:17 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id CF21972C2B4; Sun, 5 Dec 2004 22:00:56 -0500 (EST) DomainKey-Signature: a=rsa-sha1; q=dns; c=nofws; s=beta; d=gmail.com; h=received:message-id:date:from:reply-to:to:subject:cc:in-reply-to:mime-version:content-type:content-transfer-encoding:references; b=qD1/ouuhoxZtClx0hag3tqrgGQtZ7rqNwL4a8RJ8RgIFcehArg8tCRMqTuYkGsWJLCT+zHBzN2NxLb98Z0W6pNSB9+rOnXVoaOBTmo6O3hTLR0hdEODQXKlnUYy6ngOGT9qul/dVtnCBrtovBkgtI30yCSZeR+6ejp6HxVa5xTQ= Message-ID: Date: Sun, 5 Dec 2004 18:58:56 -0800 From: Jared Still To: fahd-m@aero.com.pk Subject: Re: Definition Cc: Oracle-L Freelists In-Reply-To: <002e01c4d92b$210f2bc0$c003a8c0@misinternet> Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <002e01c4d92b$210f2bc0$c003a8c0@misinternet> X-archive-position: 13135 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: jkstill@gmail.com Precedence: normal Reply-To: jkstill@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org 6. SQL that is parsed more than once. On Fri, 3 Dec 2004 16:27:53 +0500, Fahd Mirza wrote: > 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 > -- Jared Still Certifiable Oracle DBA and Part Time Perl Evangelist -- http://www.freelists.org/webpage/oracle-l