It makes sense to create minimum indices. I've a case so I needed SharePoint community's help in understanding if in worst case multiple indices may freeze entire database or just tables for this site collection?
I've a list with 35K+ items. It already have 10 indices configured while there is need to create more. Actually 20 in total. I understand that having multiple indices may result in expensive queries so will there be situation when database gets freeze? Further, how this many indices impact other site collections since multiple site collections share same content DB.