Welcome tag moderator AKA Unofficial DEV cheerleader. While most of my friends are found on SnapChat or Tic-Toc, you can find me here. And I OOP, but Iām not a VSCO girl.
Thanks Viral. It's not graphical like SQL Server, and I think it will take some time to weed through the output and see what's going on. I guess it just takes some time to learn. One more challenge for me!
Welcome tag moderator AKA Unofficial DEV cheerleader. While most of my friends are found on SnapChat or Tic-Toc, you can find me here. And I OOP, but Iām not a VSCO girl.
Katie, you are correct. One of the most commonly used tools is the
EXPLAINcommand which shows you the execution plans of the query. Read this guideon how to use Explain command to optimize your query.Thanks Viral. It's not graphical like SQL Server, and I think it will take some time to weed through the output and see what's going on. I guess it just takes some time to learn. One more challenge for me!
Oops. I just looked around in MySQL Workbench and found a graphical output for EXPLAIN. So much better now š
I see some Non-Unique Key Lookups that are taking all the execution time.
That's great.