阅读背景:

使用视图索引的Azure数据库查询优化器

来源:互联网 

SQL Server Enterprise Edition's query optimizer will use indices from a view to increase performance of a query even if the view is not explicitly referenced in the query, if applicable. Question: does Azure Database do the same thing? I know SQL Server Express does not do this, for example. I want to ensure I can still get the performance I need from the query optimizer when doing a sort on a joined table with a few million users (works great on enterprise edition but takes several seconds on express - bottle neck at the sort).SQL Server Enterprise Edition's query optimizer




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

分享到: