Translating with DrWatson… this can take a few seconds the first time.
This is a genuine, complex translation. DrWatson protects commands, error codes, and log output while naturally translating the surrounding text. It’s translated once and saved.
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
We use strictly necessary cookies to make this site work. With your
consent we’d also use optional cookies for analytics and marketing. You can accept all,
reject all, or choose. Read our Cookie Policy.