We are converting an Access database to a SQL Server back end. In doing so, we have found that our DAO method of referencing an index when opening the recordset is not supported with SQL Server.
We have gotten to the point that we have to use an "Order By" clause in our ADO-based SQL query in order to get the result set back in the order that we want. However, even with indexes on the appropriate fields, the order by is much slower than the original Access-based method (assigning the index property of the recordset).
Does anyone know of a faster method to retrieve data in a particular order from a SQL Server database using any faster method than an "Order By" clause?
We have gotten to the point that we have to use an "Order By" clause in our ADO-based SQL query in order to get the result set back in the order that we want. However, even with indexes on the appropriate fields, the order by is much slower than the original Access-based method (assigning the index property of the recordset).
Does anyone know of a faster method to retrieve data in a particular order from a SQL Server database using any faster method than an "Order By" clause?
