RE: Whatcha' wanta have?????

Paul, "Set optimization low" does not help, we've tried it. "set optimization low" only works well after 'update statistics', not after real 'alter table' I think, it's related to minor/major table version change Alexey Sonkin >From: mosserp@wellsfargo.com [mailto:mosserp@wellsfargo.com] >Sent: Monday, February 09, 2004 6:58 PM > >> That is, after executing any DDL statement that changes table >> version all >> prepared SQL statements, open cursors and stored procedures >> related to that >> table became invalid, and user session get -710 error. > >Related: Implement outstanding feature request to run "set optimization low" >from the *server* side. sending to informix-list