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,
Gpay: krishnaik06@okicici
Telegram link: t.me/joinchat/...
#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
/ @krishnaik06
-----------------------------------------------------------------------------------------------------------------------
Connect with me here:
Twitter: / krishnaik06
Facebook: / krishnaik06
instagram: / krishnaik06
-----------------------------------------------------------------------------------------------------------------------

[@deepmaurya718]

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

[@rohanrajshrivastav2029]

Sir, please keep on continuing this playlist!!

[@GreatTimeAlwaysTakeTime]

janu wait karo

[@joeljoseph26]

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!

[@ganeshgunjal4220]

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

[@sauravlabade1366]

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

[@Ai_Vijay4]

Super sir ji

[@jayeshjain4540]

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

[@Thecooltransition]

sir when will videos on one neuron be completed

[@krishnaik06]

Which course are u talking about... We are updating courses on daily basis

[@Thecooltransition]

@@krishnaik06 AIOPS

[@siddhantpathak4731]

Sir please continue it

[@tauheedgokul9579]

Sir where is the indexing can you please explain.

[@akkatiharinathreddy1488]

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

[@ranjit2391]

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

[@akshaykatti453]

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

[@vijaeendraraorao3375]

👌tq