Re: Performance problems with Online 5.03.UC1

In article <4b76v9$mki@cssun.mathcs.emory.edu> m.mejia@server1.codetel.net.do "Melvin Perez Cedano" writes: > I have Informix-Online 5.05.UC1 running on UNISYS/SVR4, recently I have been > several performance problems. I have a table with 85,000 rows aprox. and all > the indexes look right for me. I already run UPDATE STATISTICS, tbcheck -ci, > tbcheck -cI. > > I'll recreate all the indexes for that table, but if you have any idea how > improve the performance, please let me know. > > If you need to check something else, like: configuration, tbstat output, set > explain output.... I could send you later! I think that the details of the tables, columns, indexes, SELECT statement(s) and output of 'set explain' would all be *very* useful! -- ============================================================================ Sally Woolrich | This mail contains my personal sally@excelsis.demon.co.uk | views not those of my employer! ============================================================================