where is OPTCOMPIND set to???? if 2 then set it to 0

or

export OPTCOMPIND=0

start dbaccess with your problem qry.

Superboer.



"Bill Dare" <dareb@jevic.com> wrote in message news:<1108481901.fe4431bcdc1aee4b5679c325048687fb@ teranews>...
> How many rows in ano_k_out_hem? If only a few, the optimizer will do
> the sequential scan because it is more efficient than reading the index
> and the data.
>
> Bill
>
>
> > -----Original Message-----
> > From: owner-informix-list@iiug.org [SMTPwner-informix-list@iiug.org]
> > On Behalf Of hajek@nspuh.cz
> > Sent: Tuesday, February 15, 2005 5:24 AM
> > To: informix-list@iiug.org
> > Subject: serial and sequential scan
> >
> > Hi,
> > is this normal behaviour (IDS 7.31, hp-ux 10.20)?
> > from dbschema:
> > create table ano_k_out_hem
> > (
> > id_pozad serial not null ,
> > num_vysl decimal(14,6),
> > text_vysl char(30),
> > .......
> > primary key (id_pozad) constraint u3332_3326
> > );
> >
> > from sqexplain.log:
> > QUERY:
> > ------
> > update ano_k_out_hem set status_apl = "Z" where id_pozad = 2610405
> >
> > Estimated Cost: 3
> > Estimated # of Rows Returned: 1
> >
> > 1) ano_k_out_hem: SEQUENTIAL SCAN
> >
> > Filters: amis.ano_k_out_hem.id_pozad = 2610405
> >
> > from dbaccess table info:
> > Index name Owner Type Cluster Columns
> > 1006_3439 amis unique No id_pozad
> >
> >
> > So - why the sequential scan? (Update statistics (medium) is being
> > executed regularly)
> >
> > Thanks, Michal
> >
>
> sending to informix-list