Re: No future for DB2 - slightly off-topic, discusses what people are being taught at uni

"Sybrand Bakker" <postbus_at_sybrandb.demon.nl> wrote in message
> If you are involved in remote maintenance, the customer bought the
> application, the application is just a black box. Yet, when there are
> performance problems invariably the DBA is blamed, while the vendor
> plays the usual cover your ass game.
>
> IMO, you are -as usual- generalizing way too much, and even worse,
> your judgement of DBAs must be considered as offending and insulting.
> But then of course you are only 'nobody_at_nowhere.com'
> --
> Sybrand Bakker, Senior Oracle DBA

If a DBA doesn't have authority to change the indexes, or even recommend changing indexes, then that is a situation I am not talking about..

I am talking about a situation where someone says (regardless of what they have authority to change) that all foreign keys should have indexes, no exceptions. I don't believe that is correct for Oracle or DB2 (or any other RDBMS that I know about). I have explained in detail (in this and other threads) the reasons why I think that is wrong.

I have also explained that far too many DBA's are looking for simple rules that cover every situation, without having to think for themselves about how indexes and optimizers work, or without having to analyze each situation for optimum performance.

If you are offended and insulted that I think DBA's should be able to have a basic understanding of the application they are working with, and should be able to think for themselves, that is your right, but I suppose you and I shall remain very far apart (both physically and conceptually). Received on Sun Jul 31 2005 - 16:12:45 CDT