SQL indexing best practices | How to make your database FASTER!

Learn about best practices for using indexes in SQL, and how they can be used to speed up your queries, make your database faster, and improve your application's performance.

0:00 Intro
0:05 Example database table
0:15 Example query
0:21 The problem with a full table scan
0:50 Using EXPLAIN ANALYZE
1:04 What is a SQL index?
1:17 How to create a single-column index
1:37 How to create a multi-column index
2:08 Optimizing our SQL query
2:31 Caveats of sql indexes

[drugofsweetness]

"When in doubt, explain" is what i loved about this video.

[electrolyteorb]

Great video 🎉 you are just teaching Not only for CRDB but Sql dbs in general 👍

[AnatolyLeonov]

Thanks! This was a nice enlightening explanation!

[hasanmougharbel]

Hello man,
God bless your efforts.
I have a simple enquiry as a new sql learner.
How does the term b-tree relate to the index function in sql?
Thanks for taking care of this.

[MagicOfDark]

I had table without index took 18 hours to run, with index took like 6 minutes. Table had millions of entries. Also made some changes to my code, but that only shaved like 1-2 hours off.

[abhay]

You didn't mention which index you created ? Clustered or non Clustered?😊

[Deltacasper]

Would it not have been more efficient to create a separate table for the city column with additional information about the city such as region and country and reference that by Id and then index based on that instead and additionally have less redundant data or how?

[Nodsaibot]

create a JSON with the cached results :D

[teja]

Hi Sir, I have a table that consist of 16mil record and it will increase, weekly basis. to retrieve this table in Powerbi it is taking more time get this data from large SQL table. can you suggest any changes on the existing table ? current table doesn't have any indexes.

[jenweatherwax]

How many indexes should one add? And how do you know which columns to choose?

[sfcsszi]

Love this video HATE the name cockroach, disgusting