Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

But having read that in more detail it only gets you part of the way. MIN/MAX and PIVOT are not allowed in indexed views so the pivoted view can't itself be indexed. Probably not worth doing.
–
Martin SmithSep 3 '12 at 8:01

1

could you provide table definition, query and expected result? Please explain why you currently want indexed views. (adn what you want indexed). Somebody might be able to provide you with a alternative.
–
Edward DortlandSep 4 '12 at 16:44