Datasets have many methods that modify the query to change the SQL used.
Pretty much any standard SQL clause has an associated method.
Let's briefly review the most common methods.
Select changes which columns are included in each returned row.
In general, you get the best performance by only selecting the columns you will actually be using.