Sergiy (10/22/2007)

---

CustomerID unlikely to be used for ordering records in any report.

It's some internal ID nobody cares about.

In real life you need to sort by CustomerLastName (which is in another...

Sure do (you really don't want to go here, but feel free to continue). Do you know the...

Sergiy (10/22/2007)

---

And for clean test you need to try to reverse order of tests.

With no index in place Server supposes to create statistics on those columns during 1st query and...

Absolutely.

Inner Join

StmtText ...

Sergiy (10/22/2007)

---

David,

Another false statement from you:

[Code]

--===== Add an index to the CustomerID/TotalDue columns just for grins

--===== Removed the TotalDue from the index, since it quite frankly wouldn't be there...

I forgot to mention, the above two queries have identical actual execution plans. 🙂

Way too much pontificating about things, and way too little testing (I know, not everyone has the environment to test, but I'd personally be sure before I made bold claims...

Jeff Moden (10/21/2007)

---

That would be the last bit of code I posted... David, did you run the first code (select to screen) or the last code (insert into temp table)?...

I simply added the line for the starttime to the original...

Jeff Moden (10/21/2007)

---

Haven't "studied" the code... what do you mean by "Find the missing subtrahend"... like I said, I don't have 2k5 so I can't run a comparison test on...

Jeff Moden (10/21/2007)

---

My question was based on Serqiy's post saying that you didn't have a background in Math. It was an out of place question and I shouldn't have...

Here are the results of the first script provided on my testbed machine when it's not doing anything else:

Creating test table...

(1000000 row(s) affected)

00:00:11:250 Duration (hh:mi:ss:mmm)

==============================================================================

INNER JOIN method...

(1000000 row(s) affected)

00:00:30:780 Duration...

Jeff Moden (10/20/2007)

---

Heh... HOT DAMN! One performance test coming right up... somebody run the following in 2k5 'cause I still don't have it yet... I removed the ORDER...

Won't take it personal at all. 🙂

It depends on...

I already told you what above. I'll repeat it again for you.

David McFarland

---

Even better, if the end user comes back and decides they want the aggregates broken down...