July 26, 2010 at 12:26 pm
Hi!
Is there any guidance on using parallelism and indexed views? I just rewrote a dog slow query to use an indexed view, and it refused to do it. It skipped right past my customized indexes and hit the base tables, then handed the data off to an easily distracted gnome for sorting. The thing was crawling toward a minute, and it's for a user interface.
I set OPTION (MAXDOP 1) just to make the query plan easier to read, and bam! Subsecond response times. Key lookup on the view, index scan for sorting.
What gives?
Ion
August 5, 2010 at 9:02 am
Noone can answer this question as-is.
check out http://www.sqlservercentral.com/articles/SQLServerCentral/66909/
Dan Guzman - Not the MVP (7/22/2010)
All questions have to be prefaced by Server version and 'according to MS Docs' or 'my own personal opinion based on how much detail I felt like digging into at the time.'
Viewing 2 posts - 1 through 1 (of 1 total)
You must be logged in to reply to this topic. Login to reply