Thanks. I figure the DTA would at least be a start, until we get a better handle on the situation.

I've done some digging on indexes, and reading here, although not that particular Stairway (although I did e-mail it to the head developer yesterday!) so I know that sometimes even if you have an index on the column(s) you're querying, the SQL engine may find it's more "cost effective" to just scan the table.

Once more, thank you.

Jason