Comparative Technique to Optimize the Cost of Maintaining Non-Clustered Indexes in SQL Server

Provided by: International Journal of Applied Research in Computing
Topic: Data Management
Format: PDF
One of the most important features that make DBMS a better choice over a traditional file system is fast retrieval of data, which is facilitated by indexes. In a relational database every table can have at most one clustered index and many non-clustered index. Though it facilitates fast retrieval of data the cost (in terms of time) of maintaining these indexes after every insert, update and delete query increases with the size of the table, especially when the table has both clustered and non-clustered indexes on its various columns.

Find By Topic