This content has been marked as final. Show 1 reply
yes, there is some overhead if you synchronize and also query on the same tables. But this overhead isn't that much, that it should be a concern.
My question is, are you also optimizing the index? If not, then you should definitely do it, read http://docs.oracle.com/cd/E11882_01/text.112/e24435/aoptim.htm#i1006852 and the links given. A good start is to get a report about the index with CTX_REPORT.INDEX_STATS, this will give you insight on the status of the index. The next point if the index is not fragmented is to look at the queries and the memory use on the index.
Herald ten Dam