• One of the applications that i was recently looking at had 32 indexes on the indexed view(1 clustered, 31 non clustered) :hehe:.

    Last time i pulled report, it had 32000+ inserts where as only some of the indexes were actually getting used for reading. It was real bad setup. Though i agree, indexed views will increase read performance, however we must also consider the amount of writes happening to the base table.



    Pradeep Singh