Re: Need some performance help ..

In article <6lkl1j$t4b$1@titan.globalserve.net>, alvin lam <alvinlam@iname.com> writes > >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 ... > Can you please post us the file... >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. -- David Williams Maintainer of the Informix FAQ Primary site (Beta Version) http://www.smooth1.demon.co.uk Official site http://www.iiug.org/techinfo/faq/faq_top.html I see you standin', Standin' on your own, It's such a lonely place for you, For you to be If you need a shoulder, Or if you need a friend, I'll be here standing, Until the bitter end... So don't chastise me Or think I, I mean you harm... All I ever wanted Was for you To know that I care