Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Vote For New Content
Indexes
On this page

Indexes

In SQL, an index is a database object that provides a faster way to look up data in a table. Indexes optimize the retrieval of rows from a table based on the values in one or more columns.

They act like a reference or a pointer to the data, allowing the database engine to locate and retrieve the rows more efficiently.

Types of Indexes

The following are the two main types of indexes.

  • Clustered Index:

    The clustered Index determines the physical order of data rows in a table

.....

.....

.....

Like the course? Get enrolled and start learning!

On this page