0 votes
in Sql by
What is an SQL Index?

2 Answers

0 votes
by

An Index is a special structure associated with a table to speed up the performance of queries. The index can be created on one or more columns of a table.

0 votes
by

An index is a disc structure associated with a table or view that speeds up row retrieval. It reduces the cost of the query because the query's high cost will lead to a fall in its performance. It is used to increase the performance and allow faster retrieval of records from the table. Indexing reduces the number of data pages we need to visit to find a particular data page. It also has a unique value meaning that the index cannot be duplicated. An index creates an entry for each value which makes it faster to retrieve data.

For example: Suppose we have a book which carries the details of the countries. If you want to find out information about India, why will you go through every page of that book? You could directly go to the index. Then from the index, you can go to that particular page where all the information about India is given.

Related questions

0 votes
asked Jun 15, 2023 in Sql by Robin
0 votes
0 votes
asked Jan 15 in Sql by AdilsonLima
...