Optimization Review

Video Activity
Join over 3 million cybersecurity professionals advancing their career
Sign up with
or

Already have an account? Sign In »

Time
9 hours 41 minutes
Difficulty
Intermediate
CEU/CPE
10
Video Transcription
00:00
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
00:18
we can use Format equals Jason
00:20
For additional information and details such as query cost,
00:26
we can partition large tables for improved performance.
00:30
This will help us pay attention and understand the table structure as well.
00:35
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
00:55
records,
00:56
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,
01:15
that could be a serious problem because you really don't want to have to go back
01:19
and rework hundreds of queries.
01:23
Now optimization also impresses Employ yours optimization Knowledge displays an intimate understanding of databases.
01:30
Many novice sequel programmers struggle with optimization technique, so it really sets you apart from a lot of the novice programmers.
01:38
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.
Up Next
Intermediate SQL

This free course introduces the student to intermediate concepts found in the implementation and application of Structured Query Language (SQL) within professional business environments.

Instructed By