Error to create the Indexed View
I create this View with Schemabinding:
CREATE VIEW RANKING_OPTIMIZATION_VIEW
WITH SCHEMABINDING
AS
SELECT USERS.[USER_ID],
USERS.GAMERTAG,
CLASSIFICATION.WIDGET_ID,
CLASSIFICATION.CLASSIFICATIONTYPE_ID,
ROW_NUMBER() OVER(PARTITION BY CLASSIFICATION.WIDGET_ID,
CLASSIFICATION.CLASSIFICATIONTYPE_ID
ORDER BY CLASSIFICATION.[SCORE] DESC ) AS
RANKING,
CLASSIFICATION.WIN,
CLASSIFICATION.LOSE,
CLASSIFICATION.SCORE
FROM [dbo].[GMW_CLASSIFICATION] AS CLASSIFICATION
INNER JOIN [dbo].[GMW_USERS] AS USERS
ON USERS.[USER_ID] = CLASSIFICATION.[USER_ID]
INNER JOIN [dbo].[GMW_WIDGET_GAMETYPES] AS GAMETYPE
ON GAMETYPE.[WIDGET_ID] = CLASSIFICATION.[WIDGET_ID]
AND GAMETYPE.[GAMETYPE_ID] =
CLASSIFICATION.[CLASSIFICATIONTYPE_ID]
I got this error: Cannot create index on view
"GameRoomDev.dbo.RANKING_OPTIMIZATION_VIEW" because it contains a ranking
or aggregate window function. Remove the function from the view definition
or, alternatively, do not index the view.
Any ideas how to change the query?? Thanks
No comments:
Post a Comment