Named Indexes - Advantages and disadvantages

Database
Enthusiast

Named Indexes - Advantages and disadvantages

As a DBA i have seen practice of using named indexes while table creation in multiple TD shops. One of the advantage is the index maintenance as it makes an entry in DBC.INDICES ,also helping in stats collection.I heard counter argument that named indexes are maintenance nightmare and should be avoided.
Can anybody elaborate the disadvantages of named indexes if there are any?Also would like to know their other advantages beside the one i have pointed.
1 REPLY
Enthusiast

Re: Named Indexes - Advantages and disadvantages

Interesting observation !! but no idea 'bout disadvantages.
Are there any ??