Interview Bootcamp

0% completed

​

What are Indexes?

Indexes are well known when it comes to databases. Sooner or later there comes a time when database performance is no longer satisfactory. One of the very first things you should turn to when that happens is database indexing.

The goal of creating an index on a particular table in a database is to make it faster to search through the table and find the row or rows that we want. Indexes can be created using one or more columns of a database table, providing the basis for both rapid random lookups and efficient access of ordered records.

.....

.....

.....

Like the course? Get enrolled and start learning!
Yulian Stefanov

Yulian Stefanov

· 3 months ago

It would be useful if you could also cover a point of how performance is affected by indexes on columns that are meant to be used in searchbars. Since indexes resemble lookups that rely on exact match, a partial match would degrade the performance, no?

Show 1 reply