Hi,What fetch buffer size are you using in the application? How does that compare to Postgres/Mysql?https://www.ibm.com/docs/en/informix-servers/12.10?topic=performance-manage-fetch-buffer-sizeWhat is the query plan for the session? How does that compare to Postgres/Mysql?Regards,
There is a measureable delta with the select col as name syntax (or within SPL return int as name) but it is not significant – certainly not the 125% you are seeing. First came across this with Java developers when they want to rename the columns, or "<expr>" at the SQL layer rather than in the Java layer.