On Set Optimization Low

Posted in 2005

jpierrot@chubb.com — Wed, 21 Dec 2005 13:27:37 -0500 — source: Usenet: comp.databases.informix

Any thoughts on this folks - Will appreciate it. Setting "Set Optimization Low" for stored procedures is one of the suggested workaround. Have not tried it yet. Are you aware of any downfalls (pros & cons) using it in an environment. Does it impact other objects directly or indirectly in any shape, form or fashion? Will stored procedure performance degrade in any way? Are we loosing anything for having this set? Please advise! Thanks jp sending to informix-list