Hi again,

A followup question:  In general, with the given SELECT statement from the previous post, what are some good guidelines to optimize that query?  Should I just put single-column indexes...

Chris,

Thanks very much for your quick response.  After I saw your response, I looked at the execution plan, and indeed for the slow search a clustered index scan is being...

Kenneth,

Thanks again.  OK, you caught me.  I left out a couple of details, which I thought weren't relevant, but actually are.  .  Here's the missing...

Lee,

Thanks for the response.  I think I didn't explain the original problem as well as I could have.  I don't want to return all the rows on the table, I...

Kenneth,

Thanks for the quick reply.  I won't be able to try out your suggestion until tonight.  I'll let you know how it goes.

But, one additional question:  In your suggestion you...