On Monday, July 6, 2020, Michael Lewis <mle...@entrata.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.