Mailing-List: contact cocoon-dev-help@xml.apache.org; run by ezmlm
Precedence: bulk
Reply-To: cocoon-dev@xml.apache.org
Message-ID: <3E34E741.5070702@dff.st>
Date: Mon, 27 Jan 2003 09:01:05 +0100
From: Torsten Curdt <tcurdt@dff.st>
User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.0; en-US;
 rv:1.3a) Gecko/20021212
MIME-Version: 1.0
To: cocoon-dev@xml.apache.org
Subject: Re: [ESQL] Improvement....
References: <53015.10.0.0.1.1043515198.squirrel@ags01.agsoftware.dnsalias.com>
 <55229.10.0.0.1.1043621340.squirrel@ags01.agsoftware.dnsalias.com>
 <3E3469EB.8040401@dff.st> <200301271125.14977.niclas@hedhman.org>
In-Reply-To: <200301271125.14977.niclas@hedhman.org>
Content-Type: text/plain; charset=us-ascii; format=flowed
Content-Transfer-Encoding: 7bit

Niclas Hedhman wrote:
> On Monday 27 January 2003 07:06, Torsten Curdt wrote:
> 
>>>What do the database to try to find the 6th row?
>>>
>>>I think the answer is: scan the rest of the database after finding the
>>>ONLY 5 rows that already exist.
>>
>>No :) ...be sure - it doesn't
> 
> 
> Well, that depends on the WHERE clause. For instance;
> 
> WHERE SQRT(  SQ( a - b ) + SQ( c - d ) + SQ( e - f ) ) < g ;
> 
> definately go through every record, whether the fields are indexed or not.

Aaah - now I got you guys! (sorry for being that slow ;)

Antonio, how comes that you always know you have 5 rows? This sounds 
quite unusual to me...
--
Torsten


---------------------------------------------------------------------
To unsubscribe, e-mail: cocoon-dev-unsubscribe@xml.apache.org
For additional commands, email: cocoon-dev-help@xml.apache.org