I am thinking to create some indexed views as I have some of very complex queries and I am not able to optimize them further. I have already created some indexed views and getting much improved performance. But I am little bit afraid that what would happen when my database size will increase, as indexed views are nothing but object like tables which occupy space in DB and whenever DML operations perform on the participant tables it gets updated (rows get updated/deleted/inserted).
Can we partition the indexed views in same fashion as we can do with tables?
Kindly help me out?