Learning MySQL - Using Indexes

Подписаться 102 тыс.

Просмотров 62 тыс.

50% 1

This tutorial covers the different ways you can create or remove indexes on the columns in your tables. Also discussed are the different types of indexes, what they are and why you would want to use them.
MySQL playlist: • Learning MySQL - Getti...
MySQL CREATE INDEX reference: dev.mysql.com/...

Опубликовано:

6 сен 2024

Ссылка:

Скачать:

Готовим ссылку...

Добавить в:

Мой плейлист

Посмотреть позже

Комментарии : 54

@diffused4479 4 года назад

hey thanks a lot. I was so confused what indexing is. definitely not anymore! this is a very straight forward tutorial you made it so easy to understand.

@supriyjinturkar7477 4 года назад

Your voice is like Walter White from Breaking Bad !

@MilMike 2 года назад

this video is so helpful! I was confused about that you can create one index for multiple columns. You explained why it makes sense. And also that it can be bad to create many indexes because for every insert mysql is also creating these multiple indexes. Thanks!

@JeromeVIP Год назад

Dude, this video made my query like 1000% faster by just using indexes on specific items. Thank you for making this video. You are fucking awesome !

@stuknowlton160 2 года назад

Fantastic Video Thank you Steve. As usual your lessons are a life saver.

@ktoscos4546 Год назад

I remember more than 8 months ago I understood how webpack work due movie from this channel :)

@davelaff73 3 года назад

This is very clear. Thank you for helping out a noob!

@biliyonnet 5 лет назад

You really should've to make an "using indexes" course. This is more complex and more important than creating indexes. I mean that a baby can create indexes but not everyone can know how to use them.

@SteveGriffith-Prof3ssorSt3v3 5 лет назад

There is a ton of stuff that I havent added to this course. I only have so much time and I have a lot of topics to cover. This is an introductory course after all.

@alokprusty1995 3 года назад

Thanks for the video, it really gave me a clarity on Indexes

@jahnvikumari318 3 года назад

Such well-explained tutorial. Thanks a ton!!

@zohebkhan9066 4 года назад

It's extremely help full Steve.. Thanks a lot

@fawadit11 Год назад

please make a detailed video explaining multiple indexes or too many indexes how it will improve or decline the performance

@SteveGriffith-Prof3ssorSt3v3 Год назад

You can post tutorial requests in the comments here - ru-vid.com/video/%D0%B2%D0%B8%D0%B4%D0%B5%D0%BE-LCezax2uN3c.html

@be_happy_____ 2 года назад

VERY MUCH UNDERSTANDABLE THANK YOU....

@Android.26 3 года назад

*** Excellent Tutorials ***

@moonfahim 5 лет назад

Thank you Steve, it helped me a lot

@7bluestars872 4 года назад

A very helpful guide for indexes. Thank you a lot for this tutorial. Btw your voice is so similar to Christian Slater from Mr. Robot :)

@KeffelewAssefa Год назад

Great tutorial, thank you.

@jitendraruley 4 года назад

Thank you so much for making video Sir.

@rmnkot 5 лет назад

Great lessons, thanks!

@MFaisalHafeez 3 года назад

While creating index I am face error of in valid key over data table size of, 300gb

@SteveGriffith-Prof3ssorSt3v3 3 года назад

That's a fairly large table. Assuming that you are using InnoDB, here are the limits for tables with that engine - dev.mysql.com/doc/refman/5.7/en/innodb-limits.html (for version 5.7 of MySQL)

@SteveGriffith-Prof3ssorSt3v3 3 года назад

@@MFaisalHafeez I don't use Whatsapp.

@SteveGriffith-Prof3ssorSt3v3 3 года назад

@@MFaisalHafeez sorry. I dont have a guide for that

@RaihanSabuj 4 года назад

well explained, I am a bit clear now

@furkanayvaz4078 4 года назад

Thank you so much Steve, it helps me

@furkanayvaz4078 4 года назад

I want to ask you that can i use an index with same fields in several queries?

@catharperfect7036 Год назад

Cheers my fellow chimpin code puppy

@AaronEstebanSEO 2 года назад

Hi Steve, I have a question. If I were to create 3 tables, added indexes to them, and then created a view table that has UNIONED ALL 3 of those tables (or combined all 3 of those tables into the table VIEW), will the VIEW of those 3 tables combined be able to utilize the indexes on those 3 tables?

@kalifef5291 4 года назад

thank you steve

@myelibrary 3 года назад

A fantastic video, what does the ‘packed’ mean? Keep up the great work

@SteveGriffith-Prof3ssorSt3v3 2 года назад

Packed has to do with compression of certain types of columns. It is applicable to MYISAM tables.

@myelibrary 2 года назад

@@SteveGriffith-Prof3ssorSt3v3 thanks a lot for the quick reply

@moonfahim 5 лет назад

Thank you Mr Steve ! it was very nice, But can you tell me brief what are the main differences of these 4 types of Indexes ?

@SteveGriffith-Prof3ssorSt3v3 5 лет назад

Unique just ensures that each value in the column is unique. primary key indexes are the unique AND identifying value for each row. FullText is, as the name implies, an index of all the text in a large text field. A plain index is an index on any field of any datatype. Indexes are just used on fields where you will be doing a lot of searching or filtering to improve efficiency.

@MFaisalHafeez 4 года назад

nice too helpingg

@MFaisalHafeez 4 года назад

plz share ur whatsapp no or email I need more information

@fash9340 3 года назад

amazing, thanks

@amralkhatib5031 5 лет назад

thanks a lot thats really help

@nischayshah3537 4 года назад

where can we get an indepth course on mysql from you? or can you refer some other

@SteveGriffith-Prof3ssorSt3v3 4 года назад

Sorry. This is the only course on MySQL that I have created so far.

@aadil4236 4 года назад

Are you using the word 'column' and 'field' interchangeably in the video..??

@SteveGriffith-Prof3ssorSt3v3 4 года назад

Most of the time yes. Field can be used when you are talking about each item a single row or about the column.

@aadil4236 4 года назад

@@SteveGriffith-Prof3ssorSt3v3 got it thanks Mr.griffith

@adilsaju 4 года назад

Awesome

@MFaisalHafeez 4 года назад

what is way to delete million of duplicates form column

@SteveGriffith-Prof3ssorSt3v3 4 года назад

Tables should be designed with keys and indexes to prevent the duplicates being added in the first place. If you have duplicates and need to figure out which ones to remove and which ones to keep then I would suggest writing a stored procedure for that task.

@princebillygrahamkarmoker2122 4 года назад

Really helpful thank you :v

@TheCekobi 3 года назад

Your voice is like Batman

@comment8767 Год назад

"CHAR" is short for character.... so is should not be pronounced like the char in charcoal, but rather like the char in character. I am not just making this up. My computer science teacher insisted upon this.

@SteveGriffith-Prof3ssorSt3v3 Год назад

Well that's their issue. 😀