Index fragmentation [message #312337] |
Tue, 08 April 2008 10:43 |
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.
|
|
|