Learning MySQL - Using Indexes
ฝัง
- เผยแพร่เมื่อ 8 ก.ย. 2024
- 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/...
![[TH] 2024 PMSL SEA Finals D2 | Fall | ต้องรักษาฟอร์ม อย่ายอมให้ใครแซง](http://i.ytimg.com/vi/x38QsGn7A3M/mqdefault.jpg)
Your voice is like Walter White from Breaking Bad !
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.
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 !
This is very clear. Thank you for helping out a noob!
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!
Fantastic Video Thank you Steve. As usual your lessons are a life saver.
I remember more than 8 months ago I understood how webpack work due movie from this channel :)
Thanks for the video, it really gave me a clarity on Indexes
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.
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.
Such well-explained tutorial. Thanks a ton!!
It's extremely help full Steve.. Thanks a lot
*** Excellent Tutorials ***
VERY MUCH UNDERSTANDABLE THANK YOU....
Great tutorial, thank you.
Thank you Steve, it helped me a lot
please make a detailed video explaining multiple indexes or too many indexes how it will improve or decline the performance
You can post tutorial requests in the comments here - th-cam.com/video/LCezax2uN3c/w-d-xo.html
Great lessons, thanks!
Thank you so much for making video Sir.
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 :)
Thank you so much Steve, it helps me
I want to ask you that can i use an index with same fields in several queries?
thank you steve
amazing, thanks
thanks a lot thats really help
While creating index I am face error of in valid key over data table size of, 300gb
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)
@@MFaisalHafeez I don't use Whatsapp.
@@MFaisalHafeez sorry. I dont have a guide for that
well explained, I am a bit clear now
Cheers my fellow chimpin code puppy
nice too helpingg
plz share ur whatsapp no or email I need more information
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?
Awesome
where can we get an indepth course on mysql from you? or can you refer some other
Sorry. This is the only course on MySQL that I have created so far.
A fantastic video, what does the ‘packed’ mean? Keep up the great work
Packed has to do with compression of certain types of columns. It is applicable to MYISAM tables.
@@SteveGriffith-Prof3ssorSt3v3 thanks a lot for the quick reply
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 ?
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.
Really helpful thank you :v
Are you using the word 'column' and 'field' interchangeably in the video..??
Most of the time yes. Field can be used when you are talking about each item a single row or about the column.
@@SteveGriffith-Prof3ssorSt3v3 got it thanks Mr.griffith
what is way to delete million of duplicates form column
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.
Your voice is like Batman
"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.
Well that's their issue. 😀
Why does he have these many browsers lol
As a web developer I need to be able to test what I build across different platforms with different rendering engines.