Home » Server Options » Text & interMedia » Text index performance guidelines (Oracle 10.2)
Text index performance guidelines [message #380980] Wed, 14 January 2009 11:22 Go to previous message
dugjason
Messages: 13
Registered: June 2008
Location: UK
Junior Member
Hi all,

I have a quick question about the performance of Oracle Text indexes:

Are there any guidelines on what the size of DEFAULT_INDEX_MEMORY should be depending on the size of your index?
I assume I have not set DEFAULT_INDEX_MEMORY high enough, as my index is still a little fragmented after rebuilding it.

I have read through all the Oracle documentation on this subject, but I did not find any recommendations for the size I should be using.

If anyone could let me know where I could find more information about this, that would be fantastic.

Thanks in advance,

Jason

 
Read Message
Read Message
Previous Topic: Text search in SQL query
Next Topic: Problem with Catsearch and special characters in UTF8
Goto Forum:
  


Current Time: Thu Mar 28 20:22:55 CDT 2024