Take the 2-minute tour ×
Database Administrators Stack Exchange is a question and answer site for database professionals who wish to improve their database skills and learn from others in the community. It's 100% free, no registration required.

What is the performance difference between local text index and domain text index in oracle? Also what is the cost of rebuilding the domain text index when I have to split just one partition? Does the whole text index being rebuilt?

Thanks,

Sean Nguyen

share|improve this question

1 Answer 1

Sean, I believe that the local text index is part of the Oracle Text feature of Oracle that is specific to working with documents, such as Web sites, digital libraries, document or warehouses. While the Domain Indexes are indexes that we use in day-to-day.

The following documentation will be helpful: About Oracle Text: http://docs.oracle.com/cd/B28359_01/text.111/b28303/overview.htm (In the third chapter there is information about the indexes)

About the Domain Indexes: http://docs.oracle.com/cd/B10500_01/appdev.920/a96595/dci07idx.htm

share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.