Re: Deadly sins againts database performance/scalability

Norman did a great job listing the database development sins, but I have 1 more: Doing everything that Siebel enforces its customers to do! For example:
- Enforce the use of RBO instead of CBO! - Rebuild indexes periodically, in the hope that "it will help performance"
- create gazillions of indices on an OLTP system (it's not common in Siebel that more than 100 indices are defined on a table) - Have no reference integrity at the database level! - Avoid at all costs to use MV's or views!!!! (they prefer instead to use giant SQL statements).

Daniel Roy
Siebel Developer!

> Hello,
>
> I'm just creating some document how developers should/must not behave
> when dealing with Oracle database. I written down some basic rules and
> came with idea what's the most stupid thing that you can do to your
> database.
> I have two on mind, first one is not using BIND variables and the
> second one is using COMMIT in a loop statement. However, there will be
> more of these.
> So I have question to you here. What's the most stupid, but in real
> world foundable, mistakes in development applications using Oracle
> datatabase?
Received on Tue Nov 25 2003 - 16:14:05 CST