Posted by Doug on 12/16/05 20:32

it isn't what you asked, but I hate using indexed views. It seems like
every time I tried to use one, the stupid engine goes and recreates the
index from scratch doing a giant hash table in an incredibly
inefficient way not using any half way intelligent existing indexes.
So, if you used the indexed view inside a cursor, or in a stored
procedure that gets called repeatedly, the goofy thing would rebuild
itself each time it was called.

made things sooooo slowwwww.

to fix, I copied the really ugly code from the view directly into the
SPROC, documented the heck out of everything, and then the engine would
actually use already existing indexes to make intelligent decisions.

YMMV.

[Back to original message]