??? wrote: > sql4:SELECT ... FROM ... WHERE b.tileId=557467343 AND ... > Execute sql4 consumes 500-600ms, returned 5847 records > > sql5:SELECT ... FROM ... WHERE b.tileId=67430683 AND ... > Execute sql5 consumes 500-600ms, returned 14 records > > the records returned of sql5 is less than sql4, but the time is almost the > same ?
The time depends not only on the number of records returned, but also on the number of records that need to be read from disk, and searched through. Searching through lots of records that end up not matching does not reduce the time. Regards, Clemens
