> datatype of STATUS ?

I use SMALLINT. Actually, I need only two values for STATUS.

> did you a
> runstats WITH DISTRIBUTION
> on the table?, otherwise the optimizer does not know that there are
> only 2 different values for STATUS.

I didn't execute RUNSTATS WITH DISTRIBUTION on the table. I try to
execute RUNSTATS WITH DISTRIBUTION, and it works.

Thanks