Re: [ESQL] Improvement....

[Torsten Curdt]

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: [EMAIL PROTECTED]
For additional commands, email: [EMAIL PROTECTED]