Hello SingleStore,
I’m currently executing some queries on SingleStore Cloud to gather metrics of elapsed runtime of these queries. But always on the first run of the query, the elapsed time is at least 10x bigger than the other values .
I need to know the reason of this and if there’s a way to clean the database cache besides the ‘DROP ALL FROM PLANCACHE’. Is there any other command that I should run to make sure there is no cache in any step of the execution?