I see the result too, but I have to disagree on the conclusion.<br />Since not all columns are included, the second query goes for a total scan for all rows to avoid the costly key lookup, hence 481 reads.<br /><br />The first query takes only 3 reads t...

Or 1-10 5-24 (19 days) 22-30

For GroupID 1, why isn't this a valid solution? 1-10 4-26 (22 days, same as 4-20 + 15-21) 22-30

We wish to use these pages for publishing various documents, announcements, FAQ etc related to beyondrelational.com...

Better performance and nicer output

In the original sample data, how come Amount in the expected result is greater than the Amount in the Effort table? Bug? 11.1 1 2012-03-04 2012-03-01 48.9 12.1 1 2012-03-11 2012-03-01 61.1 Amount for Period 3 (March) is 50, but t

No. The idea is to encourage people to find better/different solutions. By showing the reads, we display that there are other solutions.

Yes, the absence of a proper index affects all queries, bad as good. But the difference is that a good query will using the index better and thus scale better than a bad query.