Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!newsfeed.stanford.edu!sn-xit-03!sn-xit-12!sn-xit-06!sn-post-01!supernews.com!corp.supernews.com!not-for-mail From: DA Morgan Newsgroups: comp.databases.oracle.server Subject: Re: Performance problem: anything else I can do to make this faster? Date: Thu, 03 Mar 2005 17:25:14 -0800 Organization: Ye 'Ol Disorganized NNTPCache groupie Message-ID: <1109899325.337586@yasure> User-Agent: Mozilla/5.0 (Windows; U; Windows NT 5.1; en-US; rv:1.7.2) Gecko/20040804 Netscape/7.2 (ax) X-Accept-Language: en-us, en MIME-Version: 1.0 References: <1109793882.803053.240440@l41g2000cwc.googlegroups.com> <1109799052.789107.250590@o13g2000cwo.googlegroups.com> <00fc2196m32dguelv7p3uqbqbdla0unnvi@4ax.com> <1109805174.099516.303550@f14g2000cwb.googlegroups.com> <1109805606.965366.268740@o13g2000cwo.googlegroups.com> <1109871953.020529.138170@o13g2000cwo.googlegroups.com> <1109886332.669618.34910@o13g2000cwo.googlegroups.com> <1109886635.572153.26420@f14g2000cwb.googlegroups.com> <1109887179.762042.188670@l41g2000cwc.googlegroups.com> In-Reply-To: <1109887179.762042.188670@l41g2000cwc.googlegroups.com> Content-Type: text/plain; charset=us-ascii; format=flowed Content-Transfer-Encoding: 7bit Cache-Post-Path: yasure!unknown@oracle.advtechserv.com X-Cache: nntpcache 2.4.0b5 (see http://www.nntpcache.org/) X-Complaints-To: abuse@supernews.com Lines: 21 Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:237440 sconover@gmail.com wrote: > Yep, I gathered stats on the whole schema using > dbms_stats.gather_table_stats. > > Does it make any sense that even just using the RBO a join of a table > with 1m rows with a table with 2m rows would take this long? This > doesn't seem like a big deal in terms of what Oracle can handle. Those > 1.4m logical reads are what bother me... > > Are there any obvious db environment / setup / config values that could > be off that would cause my problem? > > -Steve It makes sense to not use the RBO depending on your version. -- Daniel A. Morgan University of Washington damorgan@x.washington.edu (replace 'x' with 'u' to respond)