Re: SQL return high query cost on ids 12.10

https://github.com/domusonline/InformixScripts/blob/master/scripts/ix/ixprofilin g ./ixprofiling -w -i -t -p -e your_database sql_script_with_query Regards On Mon, May 16, 2016 at 1:32 PM, MOHD FADZIL JUSOH <fadzil@isianpadu.com> wrote: > hi, > > Are you sure these query plans are correct? yes, same query run on > different > version IDS. > > please review you I/O system? this is new for me, please advice us how to > check this? > > Also, don't compare a query run on a running engine with one on an engine > that just started.... The running engine can take advantage of an already > populated bufer cache. Don't give any credits to the estimated cost > difference. As you were already told, the calculations may defer between > different versions. The important thing is the query plan and the effective > runtime. > ok, i take noted about this. > > Please share your "ixprofiling" script to me do some testing. > > About effective runtime,that it's my point when i post this, when query > cost > high, runtime to complete this query also take longer. > > Thank you > > > > ******************************************************************************* > Forum Note: Use "Reply" to post a response in the discussion forum. > > -- Fernando Nunes Portugal http://informix-technology.blogspot.com My email works... but I don't check it frequently... --e89a8f642ea0aee91e0532f5ee61

Hi, Thank your for your script. Let we try this first. Thank you