Re: Performance problem: anything else I can do to make this faster?

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 Received on Thu Mar 03 2005 - 15:45:32 CST