Detailed notes for this lesson are being written. They appear here together with the video.
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 63 of 90
Indexes 4: composite, covering, partial and expression indexes
composite indexmulti-column indexleftmost prefix rulecolumn ordercovering indexindex-only scanINCLUDE columnspartial indexfiltered indexexpression indexfunctional indexdescending indexsargable predicatetoo many indexes