Alter index (SQL song)

Channel:

Singularonaut

Subscribers:

15,400

Published on January 9, 2024 5:17:45 PM ● Video Link: https://www.youtube.com/watch?v=SovI8frbpOA

Duration: 1:12

23 views

0

Short and fast SQL queries song, about the importance of rebuilding indexes...

Lyrics:
"USE [SchoolDB]
GO
ALTER INDEX ALL ON [dbo].[AbsentNotifications] REBUILD;
ALTER INDEX ALL ON [dbo].[AbsentNotificationTemplate] REBUILD;
ALTER INDEX ALL ON [dbo].[Absents] REBUILD;
ALTER INDEX ALL ON [dbo].[AbsentSchoolSettings] REBUILD;
ALTER INDEX ALL ON [dbo].[AcademicYearClasses] REBUILD;
ALTER INDEX ALL ON [dbo].[AcademicYearPupils] REBUILD;
ALTER INDEX ALL ON [dbo].[AcademicYears] REBUILD;
GO"