SyntaxPilot
Courses/SQL and Databases/Lesson 66
Video coming soonThis lesson’s video is being made

Start with the notes below; the video appears here as soon as it is on YouTube.

SQL and Databases · Lesson 66 of 90

Query optimisation 1: rewriting slow queries

slow querysargable rewritefunctions on indexed columnsimplicit conversion trapavoiding SELECT *OR vs UNION ALLleading-wildcard LIKEEXISTS vs IN vs JOINkeyset pagination (seek method) vs OFFSET paginationCOUNT(*) costpre-aggregation

Detailed notes for this lesson are being written. They appear here together with the video.