Re: Options to speed up a 7 table join executed frequently.
From: Bill Ferguson <wbfergus_at_gmail.com>
Date: Wed, 23 Mar 2011 06:49:47 -0600
Message-ID: <AANLkTikfyVefsB9wMywhQ557ftVpFrX3KviiS8wjAw00_at_mail.gmail.com>
Though it was kind of a pain to get setup, I had a similar problem, but one I created, not some develeopers. My approach was to setup triggers on the tables the various data pieces came from. Then in the trigger itself, I write the pertinent information into another table set up solely for these frequent queries.
Date: Wed, 23 Mar 2011 06:49:47 -0600
Message-ID: <AANLkTikfyVefsB9wMywhQ557ftVpFrX3KviiS8wjAw00_at_mail.gmail.com>
Though it was kind of a pain to get setup, I had a similar problem, but one I created, not some develeopers. My approach was to setup triggers on the tables the various data pieces came from. Then in the trigger itself, I write the pertinent information into another table set up solely for these frequent queries.
Not all that elegant, but it's a heck of a lot faster than the original way of joining all the tables together.
--
- Bill Ferguson -- http://www.freelists.org/webpage/oracle-l