@BroCodez

-- INDEX (BTree data structure)
-- Indexes are used to find values within a specific column more quickly
-- MySQL normally searches sequentially through a column
-- The longer the column, the more expensive the operation is
-- UPDATE takes more time, SELECT takes less time

-- Single column index
CREATE INDEX last_name_idx
ON customers (last_name);

-- Multi column index
CREATE INDEX last_name_first_name_idx
ON customers (last_name, first_name);

@innocentomoyibo6312

I hit the like button before I even watched the video because I knew I wasn't going to be disappointed, it's Bro code after all😂

@Esteapen

This is so cool but I have some questions:

1.) What if the table often UPDATES and also SEARCHES? Does it still applicable to add an INDEXED COLUMN?
2.) If I were to UPDATE a table with one of its column was INDEXED (but I'm not going to UPDATE the INDEXED column nor use it for WHERE condition) does it still affects the processing time? 

I hope someone will help me clarify. Thank you in advance!

@eln_ty_34_snehalsura74

You are one of the best teachers on the YouTube

@vinayaksingh524

Hey bro ! Loving the new style of content+ thumbnails , it's really neat and to the point.

@pegalolz

thanks brother im presenting a cybersecurity project in 4 days and i needed this

@maximillianquaife-larsen3799

Best video on the ropic

@cymaco_ytb8620

super cette petite vidéo notamment nous y retrouvons une explication trÚs développé et simple ce qui facilite l'aprentissage, merci de subvenir a nos besoins d'aprentissage et continuez vos vidéos pour apprendre plus au jeunes comme moi.

@geniushomwetv9793

Well Explained❀

@randmvidss

Can you please explain indexes on joins and group by etc

@amanthakur6913

You have really came a long way bro

@konstandinosdimitriou2301

this is so helpfull !

@diegogouveia1137

Hey bro, nice content

@eln_ty_34_snehalsura74

Hi bro, please also upload the videos on Flask

@UddhikaIshara

Thank you

@jagannathgaidhani5333

your MySQL workbench platform UI looks very clean! how did you do that ? mine looks very unappealing 

can you plz tell me settings options ?

@georgemilev4831

I like the video but it would have been great if you showcased it with a bigger dataset.

@tomatentheo7198

Is it possible to crate a Index over multiple tables?
For Example if i had two tables with unique keys and aggregate those to get a faster result set?

@jeanmunoz5903

Dude I don't have a very good English but I understood everything You said. Subdcribed! Have You tried teaching? You would be amazing!

@coomlord5360

Almost done with this playlist and I am so happy. Great tutorials but SQL is just so freakin boring.