无法创建我需要的索引

drop view if exists dbo.jcckd;

GO



CREATE VIEW [dbo].[JCCKD] with SCHEMABINDING

AS 

SELECT

--A.ID,

	A.xn,

	A.xq ,

	D.xy ,

	A.lsrdw,

	C.isbn ,

	C.jcmc ,

	C.cbs ,

	C.bb ,

	C.jczz,

	C.price,

	C.gys,

	C.zk,

	SUM ( B.qty ) AS cs,

	'116#' sjh,

	count_big(*) rn

FROM

	dbo.OrderHeader A

	INNER JOIN dbo.OrderDetail B ON A.ID = B.orderid

	INNER JOIN dbo.abc D ON D.id = a.custid

	INNER JOIN dbo.jcjbxxb C ON B.bookid = C.id 

WHERE



a.qty > 0 

	AND a.type = 1 

	

GROUP BY

--A.id,

	A.xn,

	A.xq,

	D.xy,

	A.lsrdw,C.isbn ,

	C.jcmc ,

	C.cbs ,

	A.lsrdw ,

	C.bb ,

	C.jczz,

	C.price,

	c.gys,

	C.zk

	;

	go

	

	

	create unique clustered index IX_lsrdw_isbn_gys on jcckd(xn,xq,lsrdw,isbn,gys)  --就这句话报错了。

	

	

	CREATE NONCLUSTERED INDEX IX_xn_xq_XY_LSRDW

    ON jcckd (xn,xq,xy,lsrdw);