Tutorial 6- Indexing In MySQL-MySQL Complete Playlist

CREATE INDEX statement in SQL is used to create indexes in tables.
The indexes are used to retrieve data from the database more quickly than others.
The user can not see the indexes, and they are just used to speed up queries /searches.
Note: Updating the table with indexes takes a lot of time than updating a table without indexes.
It is because the indexes also need an update.
So, only create indexes on those columns that will be frequently searched against.
#mysqltutorial
Subscribe @Krish Naik Vlogs channel for more educational videos on finance and investment
Please donate if you want to support the channel through GPay UPID,
#datanalyst #roadmaptobecomedatanalyst
Please join as a member in my channel to get additional benefits like materials in Data Science, live streaming for Members and many more
-----------------------------------------------------------------------------------------------------------------------
Connect with me here:
-----------------------------------------------------------------------------------------------------------------------

[deepmaurya]

With Due respect, you missed explanation about if index is created on retrieving columns or which are in where clause.

[rohanrajshrivastav]

Sir, please keep on continuing this playlist!!

[joeljoseph]

you can view the indexes created under the schema tab next to administration (below performance on your left hand side). You can find everything there!

[jayeshjain]

Sir please start a non recurring membership to join on YouTube for those who dont have a Credit Card.

[ganeshgunjal]

SHOW INDEX FROM table_name FROM db_name
we can see all from here..

[Thecooltransition]

sir when will videos on one neuron be completed

[sauravlabade]

Sir, which app you are using to write notes on laptop ? Because I'm professor in college I use powerpoint but when you try to write something on that in slide show it shows lines so please tell which app should I use

[akkatiharinathreddy]

Hi sir I am currently final year of my graduation in b.com computer applications and I want to become a data science could you help me what I do now

[ranjit]

if we add new column(age) in existing table then how to add multiple values in age column only?

[tauheedgokul]

Sir where is the indexing can you please explain.

[akshaykatti]

this index video confusing and also video on view confusing when executing query not getting proper output .