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
-----------------------------------------------------------------------------------------------------------------------
21 окт 2024
