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

To make it run faster, what you may need, in the words of Tim "the tool man" Taylor is "MORE POWER" Five Cats <cats_spam@[127.0.0.1]> wrote in message news:<VshgxhHAMrvAFwzr@[127.0.0.1]>... > In message <c9lmqf$g3m$1@news.xmission.com>, Alexey Sonkin > <alexeis@grandvirtual.com> writes > > > >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 > > Surely unless he looks at the results from set explain on, the rest is > all guesswork? Especially as we have no idea what version of Informix > he is running (could be SE for all we know) and PDQPRIORITY might not be > available? > > > > >------------------------------------------ > >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