Hi Josef!
1) Why do you group on something not an output field? I didn't think
that was allowed.
It is. I am not sure if it has any reasonable use, but it is possible.
Always good to learn something new...
2) LEFT JOIN followed by referencing to a field in the table being NOT
NULL makes
I have a query with an aggregate function (AVG) that I believe is the cause
for the very slow
execution times on the the first instance. The first execution will take
around 2.5 minutes and
subsequent queries will take around 6 seconds. I am using FB 2.5.2 in
SuperServer mode with a
page
1) Why do you group on something not an output field? I didn't think
that was allowed.
It is. I am not sure if it has any reasonable use, but it is possible.
2) LEFT JOIN followed by referencing to a field in the table being NOT
NULL makes the LEFT JOIN in reality become a (inner) JOIN,