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