cocoon-dev mailing list archives

Site index · List index
Message view « Date » · « Thread »
Top « Date » · « Thread »
From Niclas Hedhman <nic...@hedhman.org>
Subject Re: [ESQL] Improvement....
Date Mon, 27 Jan 2003 03:25:14 GMT
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.



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


Mime
View raw message