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.
