aw
2 楼
for sql server, you can try to look at "show execution plan" under sql query
analyzer -> query.
a few quick fixes: add indexes, avoid "not in", use temp tables over
cursors...
【在 c**t 的大作中提到】
: 一个复杂的Query运行时间太长，怎么知道是什么地方stall?
analyzer -> query.
a few quick fixes: add indexes, avoid "not in", use temp tables over
cursors...
【在 c**t 的大作中提到】
: 一个复杂的Query运行时间太长，怎么知道是什么地方stall?
c*t
3 楼
Yes, there is a "not in (remote select)", how to avoid it?
【在 aw 的大作中提到】
: for sql server, you can try to look at "show execution plan" under sql query
: analyzer -> query.
: a few quick fixes: add indexes, avoid "not in", use temp tables over
: cursors...
【在 aw 的大作中提到】
: for sql server, you can try to look at "show execution plan" under sql query
: analyzer -> query.
: a few quick fixes: add indexes, avoid "not in", use temp tables over
: cursors...
相关阅读
问个linux下database的问题。 (转载)有没有TSQL和 PL/SQl 或者Teradata sql都熟悉的高手， 麻烦看一下谁有amazon cloud compute的内幕消息？怎么写这个total的queryibm rdp和oracle,大家都用哪个?请教各位专家When should I reorganize Index/Rebuuild Index?求助，backup/disaster recovery plan.CBT Nuggets 70-432的VIDEO讲座招人SQL SERVER DBAsqlloader湾区公司招 MySQL Database AdministratorAccess 数据库查询facebook上那些tailored ads是怎么trigger的？问个很低级的问题：truncate 一个 table takes forever新手报到！准备考70-433Re: 金马培训出来几个月就到Fannie做Senior DBA? (转载)要学oracle挣大钱的看过来。Database Administrator position