Discover this podcast and so much more

Podcasts are free to enjoy without a subscription. We also offer ebooks, audiobooks, and so much more for just $11.99/month.

Are Indexes Actually Changes to the System

Are Indexes Actually Changes to the System

FromVoice of the DBA


Are Indexes Actually Changes to the System

FromVoice of the DBA

ratings:
Length:
3 minutes
Released:
Oct 2, 2018
Format:
Podcast episode

Description

I haven't thought about this in some time, but Brent Ozar raises an interesting question: should index changes require change control? I've worked in an organization that didn't consider an index change to be an item that was presented as an official change. They were seen somewhat like adding new users or changing a firewall rule. These were ticket requests that could be triaged and made by an individual group without notifying the rest of IT. I've also worked in organisations where an index change was viewed as a deployment and subject to change control procedures. Not that the network or security people cared about the details of the index, though the help desk might. These just wanted to be aware as any deployment change could affect their departments. Read the rest of Are Indexes Actually Changes to the System?
Released:
Oct 2, 2018
Format:
Podcast episode

Titles in the series (87)

A series of episodes that look at databases and the world from a data professional's viewpoint. Written and recorded by Steve Jones, editor of SQLServerCentral and The Voice of the DBA.