What is your deployment process for index changes? I've always searched for missing/unused/duplicate indexes directly on production and implemented changes there. Development has incorporated our database indexes into their deployment scripts so any changes I make directly on production now can conflict with their deployment scripts causing problems. By having to send index changes to development, changes take > 1 month to make it into production which, in my opinion, is often not quick enough. Obviously, making changes directly on production has its own risks. Just curious what others do. Is development involved in the index maintenance process and/or are indexes considered part of the code base / product or is it treated separately?