Sybase IQ architecture includes a portion of the product that processes queries according to Adaptive Server Anywhere rules. This feature, called CIS (formerly OMNI) functional compensation, allows queries not directly supported by Sybase IQ semantics to be processed, but with a major performance cost.
CIS intercepts queries that:
Reference a user-defined function
Include a cross-database join or proxy table
Include certain system functions
Reference a Catalog Store table or a table created in the SYSTEM dbspace
For more information on differences between Sybase IQ and Adaptive Server Anywhere, see Appendix A, “Compatibility with Other Sybase Databases,” in Sybase IQ Reference Manual.
