amin_alexi
چهارشنبه 22 آبان 1387, 15:15 عصر
سلام من با این دستور یک View ساختم !
Create View View_AM_TEST_2
WITH SCHEMABINDING
As
Select DocB.SerialNumber, DocDate, BandNo, BandSpec ,DocH.Spec, Tanzim, Taeed, Mod, TahieShode ,Type , DocH.F01 ,DocH.F02 ,Acc.Code,Acc.Name, Comm, Bede, Best
From dbo.DocB Left Join dbo.Acc On
Acc.Code=DocB.Acc_Code
Left Join dbo.DocH On
DocB.SerialNumber= DocH.SerialNumber
و بعد با این می خوام روش Index بزنم ..
CREATE INDEX [indx1] ON [dbo].[View_AM_TEST_2] ([SerialNumber])
میگه !!!!
Cannot create index on view 'View_AM_TEST_2'. It does not have a unique clustered index.
چرا ؟!
Create View View_AM_TEST_2
WITH SCHEMABINDING
As
Select DocB.SerialNumber, DocDate, BandNo, BandSpec ,DocH.Spec, Tanzim, Taeed, Mod, TahieShode ,Type , DocH.F01 ,DocH.F02 ,Acc.Code,Acc.Name, Comm, Bede, Best
From dbo.DocB Left Join dbo.Acc On
Acc.Code=DocB.Acc_Code
Left Join dbo.DocH On
DocB.SerialNumber= DocH.SerialNumber
و بعد با این می خوام روش Index بزنم ..
CREATE INDEX [indx1] ON [dbo].[View_AM_TEST_2] ([SerialNumber])
میگه !!!!
Cannot create index on view 'View_AM_TEST_2'. It does not have a unique clustered index.
چرا ؟!