Sybase Question:
Download Questions PDF

What are the catches?


Well, nothing truly comes for free. CIS is not a means of providing true load sharing, although you will find nothing explicitly in the documentation to tell you this. Obviously there is a performance hit which seems to affect cursors worst of all. CIS itself is implemented using cursors and this may be part of the explanation. OK, so how do I use it?

Easy! Add the remote server using sp_addserver. Make sure that you define it as type sql_server or ASEnterprise. Create an "existing" table using the definition of the remote table. Update statistics on this new "existing" table. Then simply use it in joins exactly as if it were a local table.

Download Sybase Interview Questions And Answers PDF

Previous QuestionNext Question
What is CIS and how can I use it?How do I capture a process s SQL in Sybase?