Grokking SQL for Tech Interviews
Ask Author
Back to course home

0% completed

Indexes
Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

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!

Table of Contents

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible

Contents are not accessible