Home » Server Options » Text & interMedia » Text index fragmented
Text index fragmented [message #152977] |
Wed, 28 December 2005 04:20  |
ankurgodambe
Messages: 45 Registered: March 2005
|
Member |
|
|
Hi,
My database version is 8.1.6 and use text index on a huge table. We have a process of recreating the index whenever the fragentation ratio goes above 8. Here is the query used:
SELECT AVG(COUNT(*)) FROM DR$index_name$I GROUP BY TOKEN_TEXT HAVING COUNT(*) > 1;
Whenever we used to re-create the index fragmentation ratio would come down to 3-4.
Recently when the fragmentation ratio reached 8, i recreated the index and instead of fragmentation ratio comming down, it went to 14. I have tried this a couple of times now and the fragmentation ration still shoots up to 14.
Does anyone have clue as to what might have gone wrong. The script for index creation is the same i used to have prevoiosly. There is no change done.
Can anyone help on this?
Thanks
-Ankur
|
|
|
|
|
|
|
|
Goto Forum:
Current Time: Mon Jul 14 07:27:55 CDT 2025
|