More SP ODBC questions

[Cantor, Scott]

I'm not aware of any table scans, but that's based on the assumption that the primary key will be used as a partial index when other operations on the context are run.

> Three of these queries require full table scans to complete.

I never found that to be true on SQL Server back in the day, but most databases are also pretty inferior to SQL Server when it comes to query optimization.

It's plausible the need to look at all the expires data might trigger that but historically it was considered a relatively bad idea to index timestamps. If it helps, great.

There's never going to be a one-size fits all answer, every database is different. I only knew SQL Server well at the time any of this was written, and that was 15 years ago, I don't have any modern knowledge of databases other than to know to avoid them.

-- Scott