阅读背景:

为什么针对MSSQL 2008SP2的ODBC查询所需的时间是Studio中相同查询的100倍?

来源:互联网 

I have a really odd query involving a join to a complex view. I analyzed the heck out of the view, built some indexes, and got the query working in under a second when run from MSSQL Management Studio. However, when run from Perl via ODBC, the exact same query takes around 80 seconds to return.I have a really odd query involving a join to a




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

分享到: