Re: [GENERAL] Runtime analysis

Neto pr writes: > I expected that the first run would always take longer than the others > because of not having cached data, but look what happened: >- in 6 cases the first execution was more faster than all executions. >- in 2 cases only, the first exececution was

[GENERAL] Runtime analysis

Hello All, I was measuring the execution time of 18 queries from the TPC-H benchmark. I run 10 times each query using the EXPLAIN ANALYZE command and store the times in a table called control_tab. To record the times, I have a java program that does the whole process as follows: Step 1: Insert