sbrownell 30624 (5/24/2010)
To what extent can your results be applied to SQL Azure? Will the indexed view method work there?
The honest answer is: I have absolutely no idea, since I have no familiarity with that product at all.
Perhaps someone else will be able to help here?
edit: Just found the following reference that shows that indexed views are available on SQL Azure:
CREATE INDEX (SQL Azure Database)
Paul White
SQLPerformance.com
SQLkiwi blog
@SQL_Kiwi