Re: Reduce or shrink the physical size of a text index
- From: "Pratap" <pratap_fin@xxxxxxxxxxxxxx>
- Date: 6 Sep 2005 01:33:49 -0700
1. May be you sync your index too often. In that case use should
optimize the index from time to time (See API for optimization). You
can do this online and this will reduce the size of the index by
eliminating the duplicate tokens in the $I table
2. Use compress 2 for $I indexes. Don't fire the alter on the $I table
directly. See the docs for how to do this for text indexes
3. See if your stoplist is intact. You may wish to introduce more noice
words in the stoplist by analyzing your data (You won't be able to
search using these words though)
Regards,
Pratap
.
- Follow-Ups:
- Re: Reduce or shrink the physical size of a text index
- From: Snewber
- Re: Reduce or shrink the physical size of a text index
- References:
- Reduce or shrink the physical size of a text index
- From: Snewber
- Re: Reduce or shrink the physical size of a text index
- From: www.twisted-nail.com
- Re: Reduce or shrink the physical size of a text index
- From: DA Morgan
- Reduce or shrink the physical size of a text index
- Prev by Date: there has another redo log analysis tool such like logminer?
- Next by Date: Re: there has another redo log analysis tool such like logminer?
- Previous by thread: Re: Reduce or shrink the physical size of a text index
- Next by thread: Re: Reduce or shrink the physical size of a text index
- Index(es):
Relevant Pages
|
