阅读背景:

SQL GROUP BY:获取索引视图的最新更新记录

来源:互联网 

I'm trying to do row versioning using an indexed view, grouping records by their key and timestamp, and taking the max(timestamp) record. This is fine, but the query I have used (see the view below) does a self join, meaning it can't be used in an indexed view, which i think will be essential to performance. Is there a way to rewrite the query so the view can be created successfully WITH SCHEMABINDING?I'm trying to do row versioning using an indexe




你的当前访问异常,请进行认证后继续阅读剩余内容。

分享到: