9 hours 41 minutes
Hi. Welcome back to Module nine. This is a lesson 9.3 optimization review and this lesson We're gonna go over the optimization topic that we covered in this course. So within optimization, we use explained to identify the execution plan of a query
we can use Format equals Jason
For additional information and details such as query cost,
we can partition large tables for improved performance.
This will help us pay attention and understand the table structure as well.
With respect to full table and index scans fulls full table scans are the most common problem found. They caused terrible performance that scales with table size. So this may go unnoticed in small applications without much data. If you have tables with 20 to a few 100
even if you've written terrible queries, it will still appear to be very quick. However, if after some time you need to add a great many deal mawr records, you're gonna find that the performance hits a wall and really slows down. And depending on how long this applications been maturing,
that could be a serious problem because you really don't want to have to go back
and rework hundreds of queries.
Now optimization also impresses Employ yours optimization Knowledge displays an intimate understanding of databases.
Many novice sequel programmers struggle with optimization technique, so it really sets you apart from a lot of the novice programmers.
The novice programmers who have trouble with optimization failed to understand why specific queries air slow. This, of course, makes it very difficult for them to fix those quarries and optimize them. So that completes the optimization review. And I hope to see in the next lesson, thank you.