Performance Evaluation in SQL Server

Abstract

Adatabase table with millionsof rowscould take a long time to retrieve, insert, update,and delete data. The evaluationin thispaperconsists of create indexes, apply normalization process, and create surrogate key to improve the performance of retrieving data. Explain the differences between multiple types of indexes and which scenarios we can use for each of them. To evaluate the improvements, one table was created in SQL server with 45 million rows. The analysis describes the resourcesand I/O statisticsused by Microsoft SQL Server Management Studio.For non-indexed tables is categorized sequentially searched and indexed table that are compared as B-tree index. Finally,the analysis was performed for normalization and composite key.Key Terms¾Microsoft SQL Server Management Studio, optimization, performance, SQL statistics