The query below performs poorly on a production database but seems fine on a development database. All the tables involved are identical, same columns, datatype, indexes, etc. The production database has slightly more records (maybe +10%). In SSMS the query takes 25-30 seconds to return any results, <1 sec on the dev copy.The query below performs poorly on a production
阅读背景：
SQL Server在生产数据库上的查询性能较差
来源：互联网
分享到：
