34 lines
1.6 KiB
Transact-SQL
34 lines
1.6 KiB
Transact-SQL
--五环增加索引，提升查询效率
|
|
CREATE NONCLUSTERED INDEX [QualityAudit_PersonQuality_LimitDate_Index]
|
|
ON [dbo].[QualityAudit_PersonQuality] ([LimitDate])
|
|
INCLUDE ([PersonId])
|
|
GO
|
|
|
|
CREATE NONCLUSTERED INDEX [Bo_Sheng_TrainPerson_ProjectId_DeleteTag_Index]
|
|
ON [dbo].[Bo_Sheng_TrainPerson] ([ProjectId],[DeleteTag])
|
|
INCLUDE ([ID],[DeleteUser],[DeleteDate],[EmpName],[IdentifyId],[Photo],[Station],[Category],[CategoryName],[RecordId],[SignName],[DepartId],[DepartName],[SignInDate],[SignInType],[TrainPeriod],[State],[TotalScore],[PassScore],[Score],[IsPass],[GroupNo],[ExamNo],[ExamCount],[DeviceNo],[OwnerDepartId],[UploadTime],[Answers],[CreateDate],[CreateUser],[OperDate],[OperUser])
|
|
GO
|
|
|
|
CREATE NONCLUSTERED INDEX [License_LicenseManager_ProjectId_Index]
|
|
ON [dbo].[License_LicenseManager] ([ProjectId])
|
|
INCLUDE ([LicenseManagerId],[LicenseTypeId],[LicenseManagerCode],[LicenseManageName],[UnitId],[LicenseManageContents],[CompileMan],[CompileDate],[States],[WorkAreaId],[StartDate],[EndDate],[ApplicantMan],[WorkStates],[IsHighRisk])
|
|
GO
|
|
|
|
CREATE NONCLUSTERED INDEX [GJSX_ProjectId_Index]
|
|
ON [dbo].[GJSX] ([ProjectId])
|
|
GO
|
|
|
|
CREATE NONCLUSTERED INDEX [WBS_BreakdownProject_ProjectId_IsSelected_Class_Index]
|
|
ON [dbo].[WBS_BreakdownProject] ([ProjectId],[IsSelected],[Class])
|
|
|
|
GO
|
|
|
|
CREATE NONCLUSTERED INDEX [ProcessControl_InspectionManagement_ProjectId_IsOnceQualified_Index]
|
|
ON [dbo].[ProcessControl_InspectionManagement] ([ProjectId],[IsOnceQualified])
|
|
INCLUDE ([InspectionId])
|
|
Go
|
|
|
|
CREATE NONCLUSTERED INDEX [Hazard_HazardSelectedItem_ProjectId_Index]
|
|
ON [dbo].[Hazard_HazardSelectedItem] ([ProjectId])
|
|
INCLUDE ([HazardLevel])
|
|
GO |