Re: informix opitmalisation

Posted in 1999

Obnoxio The Clown — Tue, 18 May 1999 06:12:57 GMT — source: Informix-list mailing list archive (1991-1998)

UPDATE STATISTICS? >From: "Krzys" <fizi@friko3.onet.pl> > >I dont know well Informix but there is a strange situation for me in query >optimalisation. >1. I have large table with rows r1,r2,r3 >2. I have 2 idndexes: i1 on (r1, r2) and i2 on (r3) >when I execute query like this "select * from table where r1=1 and r2=0 >order by r3" informix optimalisator use only index i1! so orderby statement >force informix to do physical sort data! > >thanks for any suggestions for resolving this problem > > > > ______________________________________________________ Get Your Private, Free Email at http://www.hotmail.com