Posted by Alexander Kuznetsov on 12/18/05 05:00

Doug,

I don't understand what you are speaking about. I see 2 other problems
with indexed views:

1. sometimes the optimizer just won't use them

2. there may be a lot of lock contention on them.

Can you provide more details?

[Back to original message]