By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,359 Members | 1,481 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,359 IT Pros & Developers. It's quick & easy.

LIMIT problems

P: n/a
When I execute the following query without the LIMIT clause, it executes
under 1 second. When I add the LIMIT clause, it takes 10 seconds to
complete. The client table contains 100,000 records. What is going on?

SELECT * FROM clients
WHERE rep_id = 1
AND last_name
LIKE '%au%'
ORDER BY first_name
LIMIT 0 , 10

Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.