cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Torsten Curdt <tcu...@dff.st>
Subject Re: [ESQL] Improvement....
Date Mon, 27 Jan 2003 08:01:05 GMT
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


Mime
View raw message