On Monday, July 6, 2020, Michael Lewis <mlewis(at)entrata(dot)com> wrote:
> Did you say you have an index on c1?
> [...]
> I don't know the data, but I assume there may be many rows with the same
> c1 value, so then you would likely benefit from getting that distinct set
> first like below as your FROM table.
>
Re-reading the original email I see both the answer to your question and
the data being queried.
David J.