Seems that using pragma temp_store=2 improves the speed. It now tooks 20
seconds. So now the penalty time is 9 seconds. It would possible to improve
it?.
Regards.
Iván
2013/6/17 Iván de Prado
> I have query where adding a simple "group by" by date is slowing the query
> t
I have query where adding a simple "group by" by date is slowing the query
too much, from my point of view.
The following query:
SELECT ddate, sum(hits) from a_idadvertiser_site_hostname_bench where ddate
< '2013-08-01';
runs in 12 seconds. Approximately 423,327 rows scanned per second. 1 row
re
2 matches
Mail list logo