1)Complete refresh. Cause :: client out of sync 2)index
i have two questions which im not sure if they are related in any way.
1) the select statements in my database are very slow because of the large number of records. i have realized that only the primary key-index is downloaded from the oracle 10g server to the client. therefore i have created some additional indexes that indeed made my select statements very fast.
my question is , are these extra indexes going to affect the synchronization in any way? do i need to rebuild with some kind of command the indexes or they are updated automatically when new records come from the server?
2) my second question has to do with the "Complete refresh. Cause :: client out of sync" there are many times when i try to sync and the server appears to think (or the client asks-i dont know which is the case) for a full refresh.i am not sure when exactly this is happening, since it is very hard to trace it. when does a "Complete refresh. Cause :: client out of sync" happen and why?in my case, all of the time it never actually had to do it, nothing important had changed on the server.even if i add a sequence or a new pub item, the full refresh doesnt happen(which is correct). do the indexes that i have created play any role in this happening?can i somehow stop this from occuring?
thank you for your time