Skip to Content
0
Former Member
Apr 03, 2014 at 11:09 AM

How is the -gm parameter effecting query runtime in detail?

34 Views

During test I found out, that the parameter -gm seems to have some dramatic impact onto runtime of queries. In Detail I found a something like factor 0.5 to 0.6 inside my tests for a smaller system:

-iqtc 12000

-iqmc 12000

-iqlm 1000

-gm 100

-m

-iqrlvmem 6000

When setting -gm 1001, runtimes for a single query goes up from about 10 to about 40s.

So how is the -gm parameter effecting IQ in detail?