What is the “(scanning)” variant of a loose index scan?
A query plan uses loose index scan if “Using index for group-by” appears in the “Extra” column of the EXPLAIN output. In some plans though, “Using index for group-by (scanning)” appears. What does “(scanning)” mean and how is it different from the regular loose index scan?…
Source: What is the “(scanning)” variant of a loose index scan?
