Tek-Tips is the largest IT community on the Internet today!
Members share and learn making Tek-Tips Forums the best source of peer-reviewed technical information on the Internet!
-
Congratulations IamaSherpa on being selected by the Tek-Tips community for having the most helpful posts in the forums last week. Way to Go!
Search results for query: *
- Users: AMRobinson
- Order by date
-
query speed with sybase and isql
I find that doing a simple query against a table with 114,000 records requires 9 seconds to return the results, but the same query via isql is at least ten times quicker!<br><br>select * from txn<br>where propid = getcusid<br>order by invoicenumber, txndate<br><br>this is my query, and it works...- AMRobinson
- Thread
- Replies: 2
- Forum: Sybase: Adaptive (SQL) Server
