Without distinct the view returns the sum of the uid rather than the number of uids in the column.