Hello All-
We have a question about numbers of fields in the select clause of a query and how that affects query speed.
The following query simply selects the primary key field from a table with 100,000 records:
------------------------------------------------------------
select p.opid
FROM
ott_op p
------------------------------------------------------------
It runs in about half a second (running in PgAdmin... the query run time, not the data retrieval time)
When we change it by adding fields to the select list, it slows down drastically. This version takes about 3 seconds:
------------------------------------------------------------
select p.opid, p.opid, p.opid, p.opid, p.opid, p.opid, p.opid, p.opid, p.opid, p.opid, p.opid
FROM
ott_op p
------------------------------------------------------------
The more fields we add, the slower it gets.
My guess is that we are missing a configuration setting... any ideas?
Any help much appreciated.
Thanks,
-Tom