[AccessD] ADO Recordset Procedure markedly slower with 'newer' data?

[Ryan W]

Sorry for the late reply. I do not have a cover index for this data, but I
did re-write part of the query to use a subquery and it sped it up a whole
bunch on that data. So maybe it was just inefficient to start with.

On Wed, Apr 28, 2021 at 5:23 PM John Colby <jwcolby at gmail.com> wrote:

> Possibly a "cover index" in SQL Server not covering a field used in that
> year data?  It feels like an index problem.
>
>
>