RE: How to get a faster retrun from a big query?

Alexey Sonkin said: > Try the following (sorted by priority) > > 1. Run 'update statistics' properly > 2. Run SQL under 'PDQPRIORITY' (for DSS queries only) > 3. Consider creating additional indexes > 4. Consider creating intermediate temporary tables: > - don't forget 'with no log'; > - consider creating proper indexes on temp tables > - don't forget to 'update statistics' on temp tables > after creating indexes before using them in other queries > > In fact, You might need to combine all 4 methods I think some platform info might be useful. >> -----Original Message----- >> From: karen.au@gmail.com [mailto:karen.au@gmail.com] >> >> I have a long query that needs to join 10+ tables. It will take at >> least 4 minutes to get the result. The runtime will increase as the >> tables in the query grow bigger. Is there anyways to make the runtime >> shorter? Would making temp tables and joining those tables help? >> Thanks in advance. > sending to informix-list > -- Bye now, Obnoxio "C'est pas parce qu'on n'a rien ' dire qu'il faut fermer sa gueule" - Coluche "Necrophilia means never having to say ... well, anything!" - Captain Pedantic "Ogni uomo mi guarda come se fossi una testa di cazzo" - Marco sending to informix-list