Re: Possible Feature
Posted in 2006
Topics: Performance & Tuning, Storage & Space Management, Stored Procedures & SPL
What does the Query Plan look like? As well what is the fragmentation of the Table and the Index? If they both have many small extents I would expect a little preformance gain but not something worth writing home about unless you are taking millions of rows. I would ask for the Query Plan, and Schema(s) to see if anything jumps out. PDQ? On 19 Aug 2006 16:44:48 -0700, Vitorino Ribeiro <vitorinoribeiro@gmail.com> wrote: > You're right, you can't do that. > > And I agree with you: > > Having the RETURNING LIKE <tabname>.<colname> would be a great feature: > > If I have a column of datatype CHAR(20) and I later change it to, for > example, CHAR(40), and I have a Stored Procedure or Function that > returns a value mapped to that column, then I have to: > a.) drop the procedure/function. > b.) recreate the Stored Procedure or Function with the changed > returning clause ("RETURNING CHAR(40);" instead of "RETURNING > CHAR(20);"). > c.) recreate the permissions of the Stored Procedure or Functuion. > > ... by the way the "CREATE OR REPLACE PROCEDURE / FUNCTION / VIEW / > ..." syntax (like Oracle has) would be a greate feature, too. > > > > Paul Watson escreveu: > > I haven't checked the manuals but I don't believe we can do this :) > > Just done a series of big DB changes and needed to recompile all the SPL > > code. I use 'LIKE' for the input parameters and local variables but you > > can not do a > > > > RETURNING LIKE <tabname>.<colname> syntax > > > > Would anyone else find that useful??? > > > > Cheers > > Paul > > > > Paul Watson > > Tel: +44 1414161772 > > Mob: +44 7818003457 > > Web: www.oninit.com > > > > GO FURTHER with DB2 > > GET THERE FASTER with Informix. > > Attend the IDUG 2006 European Conference. > > Vienna, Austria. 2-6 October 2006 > > Visit http://www.iiug.org/conf for more information. > > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list >