Hi folks I'm currently working with some stored procedures which were slow but are now super fast after I created some missing indexes the execution plan in SSMS told me to create. I'm not too familiar with SQL Server concepts but was hoping someone could point me in the right direction: are indexes something I can create and then forget about or do they need to be maintained long after I am gone from this project? Does a DBA need to be notified so they can look after them for example? I've read some things online but don't really understand most of it.
Thanks Tom
