peter-757102 (1/31/2012)
I took a look at the plans and what confused me is the apparent lack of clustered indexes (i noticed table scans instead of clustered index scans)!
The table names made me think these are fact and dimension tables in a data warehouse. It is not uncommon to use heaps in that scenario.
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi