From: k_rus on
I also don't think that it is acceptable. We are in touch with a
consultant from IBM US and I am not able to convince him that it is
not normal and should be investigated.

I made more experiments with sizes of the transferred data.
Queries, which selects more columns from the same table, perform the
same as with one column, i.e., 30 seconds for 2,5 million rows.
A query, which selects a column of the same type (integer), from a
bigger tables, performs worse. E.g., transferring of 7,8 million rows
takes 1 min 30 sec. I.e., linear dependency between execution time and
selected number of rows.

Best regards,
Ruslan