Home Simple Select Query taking long time to execute
Reply: 0

Simple Select Query taking long time to execute

user271
1#
user271 Published in June 22, 2018, 11:33 am
select id, subject, date, source 
from TABLE_NAME 
where source = 'ABC' 
order by date desc

The above query fetches only 917 rows (out of 300,000 rows), but needs almost 3 minutes

What could be the problem?

You need to login account before you can post.

About| Privacy statement| Terms of Service| Advertising| Contact us| Help| Sitemap|
Processed in 0.308053 second(s) , Gzip On .

© 2016 Powered by mzan.com design MATCHINFO