Does Distinct Affect Performance?
Does Distinct Affect Performance? Does distinct affect performance? 4 Answers. Yes, as using DISTINCT will (sometimes according to a comment) cause results to be ordered. Sorting hundreds of records takes time. Does distinct improve performance? Yes, the application needs to compare every record to the “distinct” records cache as it goes. You can improve performance