Skip to Main Content

Database Software

Announcement

For appeals, questions and feedback about Oracle Forums, please email oracle-forums-moderators_us@oracle.com. Technical questions should be asked in the appropriate category. Thank you!

CTXCAT vs CONTEXT

578986Mar 18 2010 — edited Mar 19 2010
Hi,
I try to understand what are differences(benefit) between CTXCAT and CONTEXT index.
According Oracle doc :
-CTXCAT is a transactional index OK But with SYNC(on commit) CONTEXT becomes also a transactional one?
-CTXCAT index is larger than CONTEXT index
-CTXCAT don't work on partionned table
-CTXCAT is less "powerfull" than CONTEXT-≥ I begin with Oracle Text and I have difficulties to understand differences(CTXCAT with CONTEXT grammar???)

Have you please some information to clarify my mind?

Thanks a lot
Comments
Locked Post
New comments cannot be posted to this locked post.
Post Details
Locked on Apr 16 2010
Added on Mar 18 2010
2 comments
3,535 views