Re: Select with lots of JOINS

From: <bdbafh_at_gmail.com>
Date: 17 May 2006 10:09:14 -0700
Message-ID: <1147885754.458514.125890@i40g2000cwc.googlegroups.com>

Perhaps for static data in lookup tables that have very few rows, you might consider caching such data in package variables or (application) contexts?

What part of the select is slow (parse, execute, fetch)? You can determine that from tracing the session and processing the trace file with tkprof.

Check the AskTom site for similar examples.

In general, not posting the Oracle database server software version and patchset will lead to only general replies, such as "have you gathered stats, are you using histograms, have you kicked the tires on the 10g R2 OEM tuning advisor (separately licensed option) and what color is the database server".

-bdbafh Received on Wed May 17 2006 - 12:09:14 CDT