View Single Post

   
  #3 (permalink)  
Old 02-25-2008, 05:44 AM
Jeremy
 
Posts: n/a
Default Re: Text Indexes: Extent specification/management

In article <e5m81q$igi$1@hypnos.nordnet.ru>, Vladimir M. Zakharychev
says...
>
> "Jeremy" <jeremy0505@gmail.com> wrote in message
> news:MPG.1ee8b0737b3e593198a1ed@news.individual.ne t...


> > I know we can set the storage options by defining storage "preferences"
> > but does anyone know if these can be applied retrospectively or do we
> > need to drop and recreate the index? It is nearing the max extents
> > default of 200 on this system.
> >

>
> For each index, Text creates a set of DR$<index_name>$<type>
> tables and corresponding indexes on these tables. You are free
> to alter their storage attributes as needed.
>
>

Many thanks Vladimir.

--

jeremy
Reply With Quote