Re: Deadly sins againts database performance/scalability

From: Anurag Varma <avdbi_at_hotmail.com>
Date: Tue, 25 Nov 2003 22:28:42 GMT
Message-ID: <uIQwb.3440$f32.1929@nwrddc02.gnilink.net>

"Daniel Roy" <danielroy10junk_at_hotmail.com> wrote in message news:3722db.0311251414.775ac3e7_at_posting.google.com...
> 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!
>

--snip--

he he .. and you would wonder how Tom Siebel who was former group vice president for Oracle USA could be incharge of an application which breaks so many rules in the Oracle world.

:) Maybe getting back at Larry and his customers ...

Anurag Received on Tue Nov 25 2003 - 16:28:42 CST