Re: Text Indexes: Extent specification/management

From: Vladimir M. Zakharychev <bob--nospam--_at_dynamicpsp.com>
Date: Thu, 1 Jun 2006 12:21:11 +0400
Message-ID: <e5m81q$igi$1@hypnos.nordnet.ru>

"Jeremy" <jeremy0505_at_gmail.com> wrote in message news:MPG.1ee8b0737b3e593198a1ed_at_news.individual.net...
>
> create index wd_web_pages_imt on wd_web_pages (text)
> indextype is ctxsys.context
> parameters('datastore wd_wp_items_pref');
>
>
> So this text index was not created with any storage options. This is
> obviously not the corect way to do things!
>
> 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.

Hth,

Vladimir M. Zakharychev
N-Networks, makers of Dynamic PSP(tm) http://www.dynamicpsp.com Received on Thu Jun 01 2006 - 03:21:11 CDT