Debating Two Viewpoints on Indexing - Development vs Operations
2025TL; DR
Who manages indexing: Ops or Dev? Join Deb and Andy for a lively debate exploring indexing from both sides. We'll debate perspectives on creation, maintenance, and troubleshooting, to help you bridge the gap in your organization.
Session Details
Who is responsible for indexing your application: operations or development?
Depending on the role, organizational structure, and access to the environment in need of indexing, the answer to that question may vary. So what should we do to make sure that our databases have the proper indexing when different roles, each with different priorities, own that responsibility?
If you can relate, and most of us can, come join Deborah and Andy for a technical yet fun debate on indexing, where we will each represent the development and operations viewpoints respectively. You can expect a lively exchange, where we will discuss various aspects of indexing, from creation, maintenance, and performance troubleshooting, from each differing viewpoint.
When you leave, you'll have a better appreciation for the "whys" that drive the two different viewpoints, enabling you to bridge the gap at your organization.
Depending on the role, organizational structure, and access to the environment in need of indexing, the answer to that question may vary. So what should we do to make sure that our databases have the proper indexing when different roles, each with different priorities, own that responsibility?
If you can relate, and most of us can, come join Deborah and Andy for a technical yet fun debate on indexing, where we will each represent the development and operations viewpoints respectively. You can expect a lively exchange, where we will discuss various aspects of indexing, from creation, maintenance, and performance troubleshooting, from each differing viewpoint.
When you leave, you'll have a better appreciation for the "whys" that drive the two different viewpoints, enabling you to bridge the gap at your organization.
3 things you'll get out of this session
1. The role that owns the responsibility of "indexing" a database, will have different priorities, thus influencing "why" they may make different Indexing decisions. We wish to explore that from the viewpoints of Ops vs Dev DBAs.
2. Examine differing priorities of Ops vs Dev DBAs when it comes to Indexing.
3. Learn pros and cons of taking different approaches to various aspects of indexing, including creation, maintenance, and performance troubleshooting.