Hi Tom, If you’re doing development, you owe it to yourself to get good at indexing.
There’s a bunch of content online. If you want something more detailed and to really understand it (which obviously I’d recommend), we have a good course on indexing here: https://training.sqldownunder.com. And you’ll also find a free course (4 Steps) there on working out what needs tuning, and how to do basic work. Regards, Greg Dr Greg Low 1300SQLSQL (1300 775 775) office | +61 419201410 mobile│ +61 3 8676 4913 fax SQL Down Under | Web: www.sqldownunder.com<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fwww.sqldownunder.com%2F&data=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091516274&sdata=SLHeEGAMmWUY5YIwcC4oAPYr%2F9RIZdi4MNASsdzwX2I%3D&reserved=0> |http://greglow.me<https://nam06.safelinks.protection.outlook.com/?url=http%3A%2F%2Fgreglow.me%2F&data=02%7C01%7Csspahelp%40microsoft.com%7C1f0ea4d6b97e4d897f3708d666d1e890%7C72f988bf86f141af91ab2d7cd011db47%7C1%7C0%7C636809449091526278&sdata=IU8tnAITCjBxWafi3A9XpO9lF3PIwZJ8ad3t36lnxvs%3D&reserved=0> From: ozdotnet-boun...@ozdotnet.com <ozdotnet-boun...@ozdotnet.com> On Behalf Of Tom P Sent: Wednesday, 3 February 2021 7:52 AM To: ozDotNet <ozdotnet@ozdotnet.com> Subject: [OT] SQL Server indexes 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
