Re: Performance - Informix SE 7.22

In article <Pine.LNX.3.96.980124191816.124A-100000@tabriz.auzeria.org>, rahim <root@auzeria.org> writes >I am working on a project on AIX/RS6000, and we are facing similar >performance problems. We did run the explain with both the programs; and >with the queries under isql and noticed that informix is doing a >sequential scan instead of using the indexes. We are doing selects from >joined tables; and yes, all our key fields are equated on the where >clause. > >Please, let me know I you find any answers to the problem. I suspect some >kind of setup or configuration problem with informix. > UPDATE STATISTICS ?? What are the table schemas and what does sqexplain.out say? How many rows per table? >**************************************************************************** > > .--. __ .--------- Rahim Azizarab > / / \\( )/ ---- 1925 S. 3rd Ave > //// ' \\/ ` --- Maywood, IL 60153 > // / / : :-- 708-344-6994 > // //..\\\\ > =UU====UU= rahim@megsinet.net > >*************************************************************************** > > -- 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