Cannot find an index that will be used for SELECT

+LEFT, TOP+BOTTOM, and RIGHT+LEFT+TOP+BOTTOM and none of them get used. All fields are FLOAT. I can't figure out how to get any index to be used, nor how to restructure my query to improve things. Thanks! - Ed Ed McNierney President and Chief Mapmaker TopoZone.com [EMAIL PROTECTED]

RE: Cannot find an index that will be used for SELECT

Arnaud - Thanks very much for a suggestion! Unfortunately, when I do that (I'm not much of a JOIN expert ) I end up selecting ALL the rows in the table. - Ed -Original Message- From: Arnaud [mailto:[EMAIL PROTECTED] Sent: Thursday, November 20, 2003 3:19 AM To: Ed McNi