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

On Sun, 31 Jul 2005 13:24:14 -0600, Mark A interested us by writing:

> But my philosophy is, regardless of the size of the table, that if an index
> will not be used (assuming that no one is going to do delete cascade or
> update on the parent division_code table), then whey have it?

This is one statement with which I can unconditionally agree.

It follows with my personal belief that the need of every index should be periodically re-evaluated, and - if it's existance can not (or can no longer) be justified, the index should be eliminated.

Thankfully, Oracle provides the ability to monitor index usage.

-- 
Hans Forbrich                           
Canada-wide Oracle training and consulting
mailto: Fuzzy.GreyBeard_at_gmail.com   
*** I no longer assist with top-posted newsgroup queries ***