Oninit cdi / Archive
Talk to an expert →

Re: On performance using views

Posted in 2008

Topics: Performance & Tuning, Stored Procedures & SPL

=?iso-8859-1?Q?Omar_Mu=F1oz?= — — source: Usenet: comp.databases.informix

I had tried setting OPTCOMPIND environment variable to zero and one (originaly it was at two), with no results. We perform a weekly "update statistics high" over all the database, without specifying tables or procedures. That means both kinds of objects are treated the same, doeant it? Thanks to everyone Omar Muñoz --- On Mon, 11/3/08, LIGHT SCANS <light_scans@yahoo.com> wrote: > From: LIGHT SCANS <light_scans@yahoo.com> > Subject: Re: On performance using views > To: informix-list@iiug.org > Date: Monday, November 3, 2008, 5:13 PM > Hello Omar, > > Superboer is right. Just one additional thought, did you > run your > update statistics the same way for your stored procedures> as you did > for your real tables? > > -L.S. > _______________________________________________ > Informix-list mailing list > Informix-list@iiug.org > http://www.iiug.org/mailman/listinfo/informix-list

↪ replying to =?iso-8859-1?Q?Omar_Mu=F1oz?=
Superboer — — source: Usenet: comp.databases.informix

you have to run upd stats for your procedures/routines. assume that OPTCOMPIND = 0 in onconfig and not set in env. what does sqexplain tell you??? Superboer. On 5 nov, 23:29, Omar Muñoz <omar...@yahoo.com> wrote: > I had tried setting OPTCOMPIND environment variable to zero and one (originaly it was at two), with no results. > > We perform a weekly "update statistics high" over all the database, without specifying tables or procedures. That means both kinds of objects are treated the same, doeant it? > > Thanks to everyone > > Omar Muñoz > > --- On Mon, 11/3/08, LIGHT SCANS <light_sc...@yahoo.com> wrote: > > > From: LIGHT SCANS <light_sc...@yahoo.com> > > Subject: Re: On performance using views > > To: informix-l...@iiug.org > > Date: Monday, November 3, 2008, 5:13 PM > > Hello Omar, > > > Superboer is right. Just one additional thought, did you > > run your > > update statistics the same way for your stored procedures> > as you did > > for your real tables? > > > -L.S. > > _______________________________________________ > > Informix-list mailing list > > Informix-l...@iiug.org > >http://www.iiug.org/mailman/listinfo/informix-list

Glossary