Re: Options to speed up a 7 table join executed frequently.
- From: Bill Ferguson <wbfergus@xxxxxxxxx>
- To: Joel.Patterson@xxxxxxxxxxx
- Date: Wed, 23 Mar 2011 06:49:47 -0600
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
--
//www.freelists.org/webpage/oracle-l
Other related posts:
