O'Reilly logo

Microsoft SQL Server 2012 Performance Tuning Cookbook by Bihag Thaker, Ritesh Shah

Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, tutorials, and more.

Start Free Trial

No credit card required

Increasing performance by creating a clustered index

Any RDBMS supports the functionality to perform the INSERT, UPDATE, and DELETE operations, and retrieve the data with the SELECT statement. As time passes by, data will increase in the database, and it will start creating an issue of slow retrieval of data whenever the SELECT statement is processed.

RDBMS is supposed to support a very large-scale database, especially when you are talking about SQL Server 2012. So, how can we eliminate this slow performance issue? Well, this is when index makes an entry into the life of a database administrator!

Prevention is always better than cure, so it is suggested that you implement proper indexes and keep changing the indexes over a period of time, if needed, ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training, learning paths, books, interactive tutorials, and more.

Start Free Trial

No credit card required