Re: data/index on different disks

From: Niall Litchfield <niall.litchfield_at_dial.pipex.com>
Date: Thu, 3 Mar 2005 20:28:40 -0000
Message-ID: <42277372$0$2763$cc9e4d1f@news-text.dial.pipex.com>

"Frank van Bortel" <fvanbortel_at_netscape.net> wrote in message news:d07c9u$pnc$1_at_news2.zwoll1.ov.home.nl...
> As text indexes are *not* updated (you need another process)
> when the data is updated, this question is even more obvious
> to answer:
> Don't bother, unless for maintenance reasons.

I'd suggest that text indexes are one of the few areas where this might make a lot of sense, precisely for the maintenance reason that Frank suggests. They tend to grow very large *and* rebuilding them reasonably regularly has some merit.

Niall Received on Thu Mar 03 2005 - 14:28:40 CST