Sql server - Describe the purpose of indexes

Describe the purpose of indexes.

- It allows the server to retrieve requested data, in as few I/O operations.
- It improves the performance.
- It is used to find the records quickly in the database without scanning the entire table.
- It is list of values in a table with the storage locations of rows.
Sql server - Determine when an index is appropriate
When there is large amount of data. For faster search mechanism indexes are appropriate........
Sql server - Syntax and an example for create, rename and delete index
CREATE INDEX index_name ON table_name (col_1,col_2..);........
What is a join and explain different types of joins
Joins are used in queries to explain how different tables are related........
Post your comment