Need for Speed...

Hi Gurus, I have a query, Tables fragmented into 5 DBSpaces, and the other tables reside into 2 DBSpaces (7 DBSpaces in all), Problem: query is to slow. How can i speed up my query. BTW, were using Metacube Server 4.x. TABLE1, TABLE2, TABLE3 fragmented in 5 DBSpace ( 5 diff. disk) TABLE4, TABLE5 ... (DBSpace6) TABLEn... (DBSpace7) Client ---> Metacube Server/Web Server ---> Informix 7.X (Browser) (Database) Regards, Jose' ------------------------------------------------------------ Why pay for Internet Service when you can get it for FREE? http://www.nettaxi.com

"jmorales@nettaxi.com" wrote: > > Hi Gurus, > > I have a query, Tables fragmented into 5 DBSpaces, and the other tables reside into 2 DBSpaces (7 DBSpaces in all), Problem: query is to slow. How can i speed up my query. BTW, were using Metacube Server 4.x. > > TABLE1, TABLE2, TABLE3 fragmented in 5 DBSpace ( 5 diff. disk) > > TABLE4, TABLE5 ... (DBSpace6) > TABLEn... (DBSpace7) > > Client ---> Metacube Server/Web Server ---> Informix 7.X > (Browser) (Database) Post the query, the schema of the two tables, SET EXPLAIN output, etc. Have you updated stats recently to at least recommended levels? Also post estimated size of each table (#rows) and of the result set of the query, your ONCONFIG file, and output from onstat -p, onstat -g ioq, and onstat -g iov. Art S. Kagel