Re: Need some performance help ..

alvin lam wrote: > > Hi > > I am using Online 7.14 engine; In 1 sql, I have to join 5 tables together; > > > > table 1 is a "orders" files which has over 12,000,000 records; > > table 2 to 5 are for description purpose. they have a little bit over 10,000 > records. > > Looking at the sqexplain.sql; the table 1 never being filtered as the first > table; which makes the execution of query so long ... > > I have try 'Update statistics' high on all the keys; but does not help at all; > > Can anyone have give me some hints ?? > > Thx > Dong. Please post a copy of your SQL. John Carlson Informix DBA WH Smith, Inc.