Topic: 创建index会加快sort吗?

  Print this page

1.创建index会加快sort吗? Copy to clipboard
Posted by: dissip
Posted on: 2006-12-25 16:03

select *
from table1
where ...
order by col1

为col1创建index 会加快上述语句吗?(where 里没有col1)

2.Re:创建index会加快sort吗? [Re: dissip] Copy to clipboard
Posted by: why
Posted on: 2006-12-26 19:19

用個別database system的工具驗證一下吧

   Powered by Jute Powerful Forum® Version Jute 1.5.6 Ent
Copyright © 2002-2020 Cjsdn Team. All Righits Reserved. 闽ICP备05005120号
客服电话 0592-8750026    客服信箱    客服QQ 714923