3 ms·Loose index scan. Its lack is why your “select distinct” is slow.by t-writescode 4y agoLoose index scan. Its lack is why your “select distinct” is slow.