select * 
from Person.Contact
where EmailAddress = 'gustavo0@adventure-works.com'

ALTER INDEX [IX_Contact_EmailAddress] ON [Person].[Contact] DISABLE;

select *
from  sys.plan_guides

set nocount on 
create table test(id int, detail int, typeid uniqueidentifier) 
create clustered index nci_typeid on test(typeid) 
go 

declare @i int =1
while @i <= 1000 begin 
insert test values (0, @i,'FE180EB8-22EB-4395-B51C-12203A8EC84F') 
set @i = @i + 1 
end 

set @i=0
while @i <= 1000 begin 
insert test values (1, @i,'CBAACF6D-ECCD-41DD-9856-D3ACBCF4BCE4') 
set @i = @i + 1 
end 
go


EXEC sp_create_plan_guide @name = N'[test-plan]', @stmt = N'select id,detail from test where typeid=@P1', 
@type = N'SQL',
@module_or_batch = N'select id,detail from test where typeid=@P1', 
@params = N'@P1 uniqueidentifier', 
@hints = N'OPTION ( TABLE HINT ( test,INDEX (nci_typeid) ) )'
GO


ALTER INDEX nci_typeid ON [dbo].[test] DISABLE;
GO

select id,detail from test where typeid='FE180EB8-22EB-4395-B51C-12203A8EC84F'
GO

SELECT plan_guide_id, msgnum, severity, state, message  
FROM sys.plan_guides  
CROSS APPLY fn_validate_plan_guide(plan_guide_id);