From oracle-l-bounce@freelists.org Fri Oct 22 14:08:20 2004 Return-Path: Received: from air189.startdedicated.com (root@localhost) by orafaq.com (8.11.6/8.11.6) with ESMTP id i9MJ8Hq11875 for ; Fri, 22 Oct 2004 14:08:17 -0500 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 i9MJ8GI11866 for ; Fri, 22 Oct 2004 14:08:16 -0500 Received: from localhost (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 8B6E572DD6F; Fri, 22 Oct 2004 14:14:26 -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 11124-47; Fri, 22 Oct 2004 14:14:25 -0500 (EST) Received: from turing (localhost [127.0.0.1]) by turing.freelists.org (Avenir Technologies Mail Multiplex) with ESMTP id 9F87872D5C0; Fri, 22 Oct 2004 14:14:24 -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=YSi0hUV4LQHbJoLVNMN6bJdFI3TeeV8pB6YPevQManDpvEVaP/alqRBMD9SXnzeiTIK1kqOCfxLyHLLBNLbIvrq3SthdKvqYDr6a7oXFzCt8Pdnm4swZtv7EZlvY9o1CX+wwyjr1e2BkcjLA0NLDIRx0+nydMvicBhr2XYMgYXA= Message-ID: Date: Fri, 22 Oct 2004 22:12:39 +0300 From: Edgar Chupit To: peter.welker@trivadis.com Subject: Re: SORT ORDER BY elimination Cc: "Oracle-L (E-mail)" In-Reply-To: <55076160AFC9C24E8D2EB831C6472BA221ECC3@MSXVS01.trivadis.com> Mime-Version: 1.0 Content-type: text/plain; charset=US-ASCII Content-Transfer-Encoding: 8bit References: <55076160AFC9C24E8D2EB831C6472BA221ECC3@MSXVS01.trivadis.com> X-archive-position: 11460 X-ecartis-version: Ecartis v1.0.0 Sender: oracle-l-bounce@freelists.org Errors-To: oracle-l-bounce@freelists.org X-original-sender: chupit@gmail.com Precedence: normal Reply-To: chupit@gmail.com X-list: oracle-l X-Virus-Scanned: by amavisd-new at freelists.org Dear Peter, Thank you very much for an answer, this post provides exact solution I was looking for. For this simple query the LIO gain is very small just 2 LIOs, but the main thing that the SORT ORDER BY step simply disappeared. I do have environment very similar to what you have described, the system is mainly OLTP with few DSS features (I must admit my problem looks exactly like you described). I will return to the list with additional information after few experiments. On Fri, 22 Oct 2004 20:08:22 +0200, Peter Welker wrote: -- Edgar -- http://www.freelists.org/webpage/oracle-l