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

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 ------------------------------------------ Alexey Sonkin > -----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