Re: Improving DSS join/sort performance.

Posted in 1998

Greg Moye — Fri, 24 Jul 1998 14:30:01 -0500 — source: Informix-list mailing list archive (1991-1998)

dmoeller@geocities.com wrote: > > Hello everyone, > > Looking for tips on increasing SQL performance when using a Data Warehouse and > a lot of joins... Just general suggestions, etc. I have a few queries that > are taking forever (an hour or more) that are doing joins where all 6 tables > involved have less than 1500 rows... This seems extreme to me for the amount > of data. I'm currently running them, changing things, running them again, snip.... Heck , that's too long even if you have a cartesian cross product with all sequential scans. I'd suggest posting the output from SET EXPLAIN with schemas and stats from the tables. -- Greg Moye The above are my opinions only.