or
execute your query
1
2
3
4
5
6
7
USE AdventureWorks
GO
SELECT CustomerID, Name, SalesPersonID, ModifiedDate
FROM Sales.Store
WHERE (Name='Bike World' AND ModifiedDate > '2004-10-01')
GO
If dbase needs an INDEX, will appear this ‘Missing Index’ green line.
Right click > Missing Index Details
This will generate T-SQL code for the missing index (SQL Server 2008 Management Studio).
1
2
3
4
5
6
7
USE [AdventureWorks]
GO
CREATE NONCLUSTERED INDEX []
ON [Sales].[Store] ([Name],[ModifiedDate])
GO
name the INDEX name
1
CREATE NONCLUSTERED INDEX [IDX_Store_Mod_Date]
#create #index #missing
origin - https://www.pipiscrew.com/?p=14499 create-missing-index-on-a-table-on-ssms-2008-and-above