Home » Server Options » Text & interMedia » Index fragmentation
Index fragmentation [message #312337] Tue, 08 April 2008 10:43 Go to previous message
Agus211
Messages: 39
Registered: September 2007
Member
Hi, i'd like to know if you could explain me why does everytime that I create a new Text index in my table and execute de ctx_report.index_stats, it tells me that the index is fragmentated(always more than 70/80%). Am I missing something?.

My table contains 5 columns(3 VARCHAR2, 1 NUMBER and a CLOB). The index uses a multicolumn datastore that contains 2 of the VARCHAR2 column's and the CLOB.

The performance when I query isn't as good as I expected also. Could this be the reason?.

Thanks in advance.
 
Read Message
Read Message
Read Message
Read Message
Read Message
Previous Topic: Help in building a Ultra Search Query using Java API
Next Topic: Trying to create Index with Multi column Datastore parameter gives error
Goto Forum:
  


Current Time: Fri Mar 29 03:11:57 CDT 2024