"Niall Litchfield" <n-litchfield_at_audit-commission.gov.uk> wrote in message
news:3f686035$0$15777$ed9e5944_at_reading.news.pipex.net...
> "Noons" <wizofoz2k_at_yahoo.com.au> wrote in message
> news:3f684182$1$14558$afc38c87_at_news.optusnet.com.au...
> > If you want to preempt maintenance of indexes possibly causing
> > contention to tables,
>
> Maintenance of Indexes wots that then? :( Seriously how often are index
> rebuilds actually necessary these days? Once a year?
>
They might just want to add a column to an index.
Or remove one? Or partition an index that wasn't?
Or build a FBI? As a result of a tuning exercise.
That's maintenance as well, no? I'd rather incur
the overhead of that somewhere else other than smack
bang in the middle of my tables.
--
Cheers
Nuno Souto
wizofoz2k_at_yahoo.com.au.nospam
Received on Wed Sep 17 2003 - 08:41:41 CDT
