SQL Indexes Clustered and Non Clustered

 Hey Guys, I hope that you are enjoying with my blogs writing and today's we will cover some  "SQL SERVER" Concepts.

Microsoft SQL Server is a relational database management system, or RDBMS, developed and marketed by Microsoft.

As a database server, it is a software products with primary function of storing and retrieving data as requested by other software application.

Initial Releases is April 24, 1989;

Indexes

• Indexes Improves the performance of search or An index is one of the important paths to make the performance of SQL server database high. 
•  An index is a pointer to data in a table.
•  It helps to speed up select queries and Where clause but it slow down data input with the Insert, Update and Delete. 
• They are stored in a B- tree structure (Balance search tree) that helps SQL Server users quickly and efficiently find the rows or associated with key values.
•  Defragmentation in SQL, It changes the physical ordering of data (as it loses contiguous allocation) and the retrieval becomes time consuming, resulting in slow database performance. 

 Types of SQL Server Indexes

• There are two types of Indexes in SQL server.

        1. Clustered  2. Non-Clustered