You can actualy do this in one select using WHERE clause for the fields with indexes and HAVING clause for the rest.
>Have a few indexes on most used queries. For example, Primary Key, Customer Number, Name, State, etc. Run a query using those indeces. Then if you need to limit the information by something that you don't have an index on, say by a particular zip code, query this intermediate table. Because you are looking at a smaller set of data, the non-indexed query should be faster.
>
>>
>>Craig,
>>
>>You said "...retrieving a subset using the index..." What do you mean exactly?
>>
--sb--