Hello! I am wondering, if no fields in a query are aggregated, then is there an advantage to using 

distinct

 over grouping by all the fields? For example, is there a difference in efficiency between these two?

select distinct species, name from dataSource

 

select species, name from dataSource group by species, name

I think the second one might be rewritten as the first one internally

Ok gotcha. so using

distinct

is more efficient internally? but from our perspective it doesn’t matter.

I think internally the group-by is only for aggregation queries, so there's nothing to compare against.

Alright, thanks!

please use distinct for now, we have some cool enhancements coming that will be applicable to distinct

Ok great!