On Jun 14, 2006, at 16:15 UTC, Igor Tandetnik wrote: > > SELECT <fields> FROM <table> WHERE recID IN (<record IDs>) ORDER BY > > dateFld > > Why not just > > select <fields> from <table> order by dateFld; > > ?
Because that gets me all records. I only want those in my list of record IDs (which comes from another source, outside the database). > Can you show the exact query you use? Well, no, because there are about 20 fields in <fields> and 13000 values in <record IDs>. Note that <fields> does include both recID and dateFld, if that matters. But apart from showing the actual field and value list, and the table name, the above query IS the exact query I use. > There must be more to your query - something that prevents an index on > dateFld from being used. That's what it seems; I just can't imagine what that could be. Thanks, - Joe -- Joe Strout -- [EMAIL PROTECTED] Verified Express, LLC "Making the Internet a Better Place" http://www.verex.com/
