View üzerine Index ekleme

alter view [dbo].[vm_testb] WITH SCHEMABINDING
as
select card_number,	
	   right(card_number,8) as card_number_short
from dbo.TestB
GO


CREATE unique CLUSTERED INDEX vm_testb_uni
ON dbo.vm_testb (card_number)
GO

CREATE nonCLUSTERED INDEX vm_testb_not_uni
ON dbo.vm_testb (card_number_short)
go

select *
from TestB
where RIGHT(card_number,8) = 17378223

select *
from vm_testb
where card_number_short = 17378223

Ek bilgi: http://gaffarsalkim.blogspot.com.tr/2012/05/ms-sql-de-with-schemabinding.html

Bunlar da hoşunuza gidebilir...