Very slow adding where clause #344
Unanswered
DineshS-nd
asked this question in
Q&A
Replies: 1 comment
-
Hi @DineshS-nd , can you test the execution time of the two queries: "select * from table limit 1000000" and "select time_stamp, driver_id, vehicle_id from table where time_stamp >= '2022-08-10' and time_stamp < '2022-08-11' |
Beta Was this translation helpful? Give feedback.
0 replies
Sign up for free
to join this conversation on GitHub.
Already have an account?
Sign in to comment
-
It is very fast when I run ""select * from table limit 1000000". But very slow when adding where clause.
"select time_stamp, driver_id, vehicle_id from table where time_stamp >= '2022-08-10' and time_stamp < '2022-08-11'
and driver_id>0 and vehicle_id>0 limit 10000" .
Please explain the reason behind and how to overcome this problem.
Beta Was this translation helpful? Give feedback.
All reactions