SyntaxPilot
Courses/SQL and Databases/Lesson 60
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 60 of 90

Indexes 1: what an index is and when it helps

indexCREATE INDEXDROP INDEXCREATE UNIQUE INDEXfull table scanindex lookupselectivitycardinality (distinct values)write amplificationindex maintenance costwhen not to index

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