What is Index ?
--Indexes in sql server are similar to indexes in textbooks like it is physical structure which pointing the data
--if we use indexes it will increase the speed sqlserver query execution
-- if we use indexes quickly locate the records in table more efficiently
--Indexes are used to improve the performance queries
--Indexes in simple language if we are using the column repeatedly in queries which is other than primary key than we make that column as Index so it will save the data into data pages in disk with index of That repeated column so if we use this column it will directly go to this index and retrieve the data more quickly and efficiently
we can also create indexes for primary keys also
which column should i create indexes
Primary Key Column
Foreign key column
frequently used column in where clause
where should not use this indexes ?
The column which are not used frequently used in where clause
columns containing the duplicate and null values
columns containing image, binary information and text information
--Indexes in sql server are similar to indexes in textbooks like it is physical structure which pointing the data
--if we use indexes it will increase the speed sqlserver query execution
-- if we use indexes quickly locate the records in table more efficiently
--Indexes are used to improve the performance queries
--Indexes in simple language if we are using the column repeatedly in queries which is other than primary key than we make that column as Index so it will save the data into data pages in disk with index of That repeated column so if we use this column it will directly go to this index and retrieve the data more quickly and efficiently
we can also create indexes for primary keys also
which column should i create indexes
Primary Key Column
Foreign key column
frequently used column in where clause
where should not use this indexes ?
The column which are not used frequently used in where clause
columns containing the duplicate and null values
columns containing image, binary information and text information
