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, ...
Get Microsoft SQL Server 2012 Performance Tuning Cookbook now with the O’Reilly learning platform.
O’Reilly members experience books, live events, courses curated by job role, and more from O’Reilly and nearly 200 top publishers.