怎么建立索引消除order by对性能的影响?
数据量在10万条左右,查询语句如下
select ID ," + tdEnName + " from " + tdTableName + " where TRANSFERID ='" + getCookies("user_id") + "' and archid = '" + archID + "'and " + DropDownList1.SelectedItem.Value + " like '%" + ASPxTextBox1.Text.ToString().Trim() + "%' and checkstatus like '%" + ASPxCbstatus.SelectedItem.Value + "%' order by ID desc
经测试带"order by ID desc"与不带"order by ID desc"的查询语句,所耗用的时间相差10多倍,怎么建立索引消除"order by ID desc"所带来的对性能的影响???