阅读背景:

错误的SQL统计信息如何在40行表上发出请求需要一分钟?

来源:互联网 

After two hours trying to figure out why my (quite simple) SQL query on a few quite empty views was taking over a minute to execute, I eventually did an "update statistics" on the impacted views, and my query instantaneously went down to a more acceptable instant result.After two hours trying to figure out why my (qu




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

分享到: