Sybase IQ 12.6 helps you make instantaneous decisions on a seamless view of operational and historical data. Several new features improve compatibility and performance when you use Sybase IQ together with Adaptive Server Enterprise.
“IDENTITY/AUTOINCREMENT columns”
“Permanent table creation with SELECT INTO (behavior change)”
“CHECK constraints enforced (behavior change)”
“Constraints can now be named”
“Owner specification with temporary tables (behavior change)”
“Subqueries supported in SELECT lists and SET clauses”
“Improved query optimization”
“Positioned UPDATE and DELETE (updatable cursors)”
“Improved performance for INSERT...VALUE statements”
