Path: dp-news.maxwell.syr.edu!spool.maxwell.syr.edu!drn.maxwell.syr.edu!news.maxwell.syr.edu!postnews.google.com!o13g2000cwo.googlegroups.com!not-for-mail From: sconover@gmail.com Newsgroups: comp.databases.oracle.server Subject: Re: Performance problem: anything else I can do to make this faster? Date: 3 Mar 2005 13:45:32 -0800 Organization: http://groups.google.com Lines: 17 Message-ID: <1109886332.669618.34910@o13g2000cwo.googlegroups.com> 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> NNTP-Posting-Host: 64.125.40.33 Mime-Version: 1.0 Content-Type: text/plain; charset="iso-8859-1" X-Trace: posting.google.com 1109886336 11297 127.0.0.1 (3 Mar 2005 21:45:36 GMT) X-Complaints-To: groups-abuse@google.com NNTP-Posting-Date: Thu, 3 Mar 2005 21:45:36 +0000 (UTC) User-Agent: G2/0.2 Complaints-To: groups-abuse@google.com Injection-Info: o13g2000cwo.googlegroups.com; posting-host=64.125.40.33; posting-account=mNbqKQ0AAABIp8AikqhOemqkA_BjiQIP Xref: dp-news.maxwell.syr.edu comp.databases.oracle.server:237403 Sarcasm is understandable, what you're saying is a common reaction (part of why I didn't bring it up until now). Our app is the only one hitting this db, and with a test-driven app there's no real reason to have constraints other than a sanity -check - which I'm not opposed to, but it's not my top priority by any means. Ordinary O/S files don't do lock management, and they lack a query language as powerful as sql. There's obviously a lot of value to be had from a db (oo or relational) that has nothing to do with constraint checking. In any case, I put the correct primary and foreign key constraints on my tables and it has no effect on performance/plan/stats. Regards, Steve