假如下面的两句在子查询中,有两中排序方式
select top 100 percent ProjID,ProjName,ProjStates from tbProjectBase order by ProjOrder
select * from tbProjectBase with(index(IX_ProjOrder)) ----在表tbProjectBase的ProjOrder字段上做了一个索引
假如下面的两句在子查询中,有两中排序方式
select top 100 percent ProjID,ProjName,ProjStates from tbProjectBase order by ProjOrder
select * from tbProjectBase with(index(IX_ProjOrder)) ----在表tbProjectBase的ProjOrder字段上做了一个索引