SQL Server·Practice drills 4

Drill 19: Improve it — Indexes

Add one improvement and explain the benefit.

Intermediate 5 min read Lesson 98 of 150 Challenge included
What you will be able to do
  • Add one improvement and explain the benefit.

Practice task

Add one improvement and explain the benefit.

index.sqlSQL
CREATE INDEX IX_lessons_course_minutes
ON lessons (course_id, minutes);
Your turn

Write your answer

Easy

Add one improvement and explain the benefit.

TEXT · starter
Your answer…
Study tools

Make it yours.

Keep a private note for this lesson, then turn the key ideas into flashcards you can revisit.

Sign in to save notes and flashcards.Both are private to your account and stay with your progress.
Sign in
Finished reading?

Lock in what you just learned.

Mark this lesson complete to save your place and move one step closer to the certificate.

Lesson 98 of 150 · 0% of course