USE LegitimateKZN
GO

CREATE NONCLUSTERED INDEX Licences_IsLatestIssue
ON [Verified].[Licences] ([IsLatestIssue])
INCLUDE ([ApplicationRequestDetailID],[LicenceStatusID],[MemberID],[VehicleID],[OperatingLicenceNumber],[DateOfExpiry])

GO


USE [LegitimateKZN_OLAS]
GO

CREATE NONCLUSTERED INDEX ImportedLicences_VerifiedLicenceID
ON [dbo].[ImportedLicences] ([VerifiedLicenceID])

GO

USE [LegitimateKZN_OLAS]
GO

CREATE NONCLUSTERED INDEX [<Name of Missing Index, sysname,>]
ON [dbo].[ImportedLicences] ([VerifiedLicenceID],[ApplicationRequestDetailIDInProgress])

GO

