Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!transit.news.xs4all.nl!border2.nntp.ams.giganews.com!nntp.giganews.com!lightspeed.eweka.nl!newshub3.home.nl!newshub1.home.nl!home.nl!not-for-mail From: Frank van Bortel Newsgroups: comp.databases.oracle.server Subject: Re: Performance problem: anything else I can do to make this faster? Date: Thu, 03 Mar 2005 19:55:18 +0100 Organization: @Home Benelux Lines: 24 Message-ID: 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> Reply-To: fvanbortel@netscape.net NNTP-Posting-Host: cc28855-a.hnglo1.ov.home.nl Mime-Version: 1.0 Content-Type: text/plain; charset=ISO-8859-1; format=flowed Content-Transfer-Encoding: 7bit X-Trace: news5.zwoll1.ov.home.nl 1109875974 5415 212.204.168.125 (3 Mar 2005 18:52:54 GMT) X-Complaints-To: usenet@corp.home.nl NNTP-Posting-Date: Thu, 3 Mar 2005 18:52:54 +0000 (UTC) User-Agent: Mozilla Thunderbird 1.0 (Windows/20041206) X-Accept-Language: en-us, en In-Reply-To: <1109871953.020529.138170@o13g2000cwo.googlegroups.com> Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:237387 Steve C wrote: > I'm finally getting the CBO to use indexes (on the count query, at > least) using: > > alter session set optimizer_index_cost_adj = 50; > alter session set optimizer_index_caching = 90; > > My query times aren't changed much though, for the count query it's 2 > seconds, for the record page query it's 5. > > One thing: I haven't put primary or foreign keys on my tables. As a > rule we don't rely on the database to do constraint checking. Would > this figure into the optimizer's decisions around join strategies, etc? Beg your pardon? You mean to say you don't use a database - you just have a big bucket with data... I haven't followed the thread in detail to make comments about CBO decisions, but not having constraints... Oracle V6 time; no foreign key constraints (well, not functional) -- Regards, Frank van Bortel