469,568 Members | 1,424 Online
Bytes | Developer Community
New Post

Home Posts Topics Members FAQ

Post your question to a community of 469,568 developers. It's quick & easy.

LIMIT problems

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
DESC
LIMIT 0 , 10


Jul 19 '05 #1
0 1651

This discussion thread is closed

Replies have been disabled for this discussion.

Similar topics

2 posts views Thread by Christian Tismer | last post: by
reply views Thread by Fatso | last post: by
5 posts views Thread by Jesper Rnn-Jensen | last post: by
2 posts views Thread by Mike | last post: by
6 posts views Thread by Hannu | last post: by
10 posts views Thread by Vic Spainhower | last post: by
10 posts views Thread by elventear | last post: by
30 posts views Thread by Jeff Bigham | last post: by
reply views Thread by suresh191 | last post: by
4 posts views Thread by guiromero | last post: by
By using this site, you agree to our Privacy Policy and Terms of Use.