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