Re: On performance using views

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 wrote:

> From: LIGHT SCANS
> Subject: Re: On performance using views
> To: informix-list-at-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-at-iiug.org
> http://www.iiug.org/mailman/listinfo/informix-list

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 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 aretreated the same, doeant it?
>
> Thanks to everyone
>
> Omar Muñoz
>
> --- On Mon, 11/3/08, LIGHT SCANS wrote:
>
> > From: LIGHT SCANS
> > 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