124 reputation
4
bio website
location
age
visits member for 1 year, 9 months
seen Mar 8 '13 at 21:23

By day I run a data warehouse and distributed datastores, so I do a lot of procedural programming. In my free time, I'm learning python/django/web technologies.


Sep
24
awarded  Autobiographer
Mar
8
awarded  Supporter
Feb
15
awarded  Scholar
Feb
15
accepted How can I make sure the SQL Server query optimizer uses the exact tables in the query
Feb
15
comment How can I make sure the SQL Server query optimizer uses the exact tables in the query
Thanks for this thorough answer Paul. It's cleared up some lingering questions for me. If I continue to have an issue, I'll post those additional details you mentioned.
Feb
14
comment How can I make sure the SQL Server query optimizer uses the exact tables in the query
@ElectricLlama - I agree that the iView would be quicker. But, my problem isn't with the iView itself, it's when the plan uses the iView support tables (thin_table) that I have an issue. They are not indexed. I could run the explain plan and test all the iViews and index the thin_ tables accordingly, but I'm looking for a minimally invasive jump to 2008 (read: no load changes) if possible.
Feb
14
comment How can I make sure the SQL Server query optimizer uses the exact tables in the query
@PaulWhite - I'm trying to avoid doing this query by query if possible, since it would require a great number of changes and testing to which query used which plan. With 2012 change you mentioned, I may need to just change my iViews to use the dimensions rather than the thin_ table.
Feb
14
awarded  Student
Feb
13
asked How can I make sure the SQL Server query optimizer uses the exact tables in the query