Improve the performance by using Indexing in SQL

Index in SQL

have you ever faced slowness while fetching the records in the SQL. If yes, then you are at the right place 😉. First let’s understand the reason behind it.


Types Of Index :-

1) Clustered Index:-

Without Indexing:-

If we don’t use any index in the table then SQL will visit all the records row by row hence execution time will get increased if records are in the thousands or more than that.

With Clustered Index:-

If we use clustered index then execution time will get decreased.

love ❤ coding, solving some industry problems technologies: JavaScript, C#, Angular, PLSQL, Docker Want to learn: Python, Go language, AI, ML and Cloud