Return-Path: Delivered-To: apmail-db-derby-dev-archive@www.apache.org Received: (qmail 38543 invoked from network); 4 Aug 2005 23:00:37 -0000 Received: from hermes.apache.org (HELO mail.apache.org) (209.237.227.199) by minotaur.apache.org with SMTP; 4 Aug 2005 23:00:37 -0000 Received: (qmail 72418 invoked by uid 500); 4 Aug 2005 23:00:35 -0000 Delivered-To: apmail-db-derby-dev-archive@db.apache.org Received: (qmail 72396 invoked by uid 500); 4 Aug 2005 23:00:35 -0000 Mailing-List: contact derby-dev-help@db.apache.org; run by ezmlm Precedence: bulk list-help: list-unsubscribe: List-Post: List-Id: Reply-To: "Derby Development" Delivered-To: mailing list derby-dev@db.apache.org Received: (qmail 72382 invoked by uid 99); 4 Aug 2005 23:00:35 -0000 Received: from asf.osuosl.org (HELO asf.osuosl.org) (140.211.166.49) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Aug 2005 16:00:35 -0700 X-ASF-Spam-Status: No, hits=2.6 required=10.0 tests=DNS_FROM_RFC_ABUSE,DNS_FROM_RFC_POST,DNS_FROM_RFC_WHOIS,SPF_HELO_FAIL X-Spam-Check-By: apache.org Received-SPF: neutral (asf.osuosl.org: local policy) Received: from [32.97.182.144] (HELO e4.ny.us.ibm.com) (32.97.182.144) by apache.org (qpsmtpd/0.29) with ESMTP; Thu, 04 Aug 2005 16:00:25 -0700 Received: from d01relay04.pok.ibm.com (d01relay04.pok.ibm.com [9.56.227.236]) by e4.ny.us.ibm.com (8.12.11/8.12.11) with ESMTP id j74N0Wkg027327 for ; Thu, 4 Aug 2005 19:00:32 -0400 Received: from d01av03.pok.ibm.com (d01av03.pok.ibm.com [9.56.224.217]) by d01relay04.pok.ibm.com (8.12.10/NCO/VERS6.7) with ESMTP id j74N0WRX172760 for ; Thu, 4 Aug 2005 19:00:32 -0400 Received: from d01av03.pok.ibm.com (loopback [127.0.0.1]) by d01av03.pok.ibm.com (8.12.11/8.13.3) with ESMTP id j74N0WCx024818 for ; Thu, 4 Aug 2005 19:00:32 -0400 Received: from [9.72.134.65] (ws420-1.usca.ibm.com [9.72.134.65]) by d01av03.pok.ibm.com (8.12.11/8.12.11) with ESMTP id j74N0VB3024776 for ; Thu, 4 Aug 2005 19:00:32 -0400 Message-ID: <42F29DF1.7030105@sbcglobal.net> Date: Thu, 04 Aug 2005 16:00:01 -0700 From: Mike Matrigali User-Agent: Mozilla Thunderbird 0.7.2 (Windows/20040707) X-Accept-Language: en-us, en MIME-Version: 1.0 To: Derby Development Subject: Re: jira question References: <42E97A33.2020204@sun.com> <42EAD360.3020108@sun.com> <42EE5278.506@sbcglobal.net> <6.2.3.4.2.20050802220509.035868c0@pop.rcn.com> <42F0CCBA.80501@sun.com> <42F10D2C.1060804@Sourcery.Org> <42F11CAB.3080001@sun.com> <42F12D5A.6070902@sbcglobal.net> In-Reply-To: X-Enigmail-Version: 0.85.0.0 X-Enigmail-Supports: pgp-inline, pgp-mime Content-Type: text/plain; charset=us-ascii Content-Transfer-Encoding: 7bit X-Virus-Checked: Checked by ClamAV on apache.org X-Spam-Rating: minotaur.apache.org 1.6.2 0/1000/N yes, and then costing and choosing an index based on the expression if it is the best way to execute the query. Manish Khettry wrote: > On 8/3/05, Mike Matrigali wrote: > >>I don't think I am willing to say generated columns are not useful without >>indexes, sorry if previous email led to that, actually I have not >>actually thought much about it. >> >>I believe I was letting >>my predjudice through, I have always thought that an interesting set >>of problems could be solved if the optimizer work was done - so I >>was concentrating on that. And I see that optimizer work as a stepping >>stone to even more possible interesting stuff in the future - things >>like gist indexes. >> > > > So the optimizer work that you speak of is being able to check if two > expressions are equivalent? >