- 论坛徽章:
- 0
|
执行了一条sql语句,运行25秒后出现以下提示。求助。我连接的是sqlserver数据库。
进行多表操作,每张表有记录约2000W条.在SQLSERVER查询时间为4分钟。这条语句在SQLSERVER查询分析器中执行成功的。
select a.province,count(province) as num from IvrUserInfo as a where exists(select * from IvrSentRecord b where a.mobile=b.mobile) group by a.province
Database error: Execute SQL: mssql_query(select a.province,count(province) as num from IvrUserInfo as a where exists(select * from IvrSentRecord b where a.mobile=b.mobile) group by a.province,Resource id #4) failed.
真不知哪里出错了,大家帮助一下。如果这条语句改成select * from ivruser就可以成功执行的。 |
|