Click here to view and discuss this page in DocCommentXchange. In the future, you will be sent there automatically.

SQL Anywhere 12.0.0 » SQL Anywhere Server - SQL Usage » Query optimization and execution » Improving query performance


Disk allocation for inserted rows

The following section explains how rows in the database are stored on disk.

 SQL Anywhere stores rows contiguously, if possible
 SQL Anywhere may store rows in any order
 Space is not reserved for NULL columns
 Once inserted, rows identifiers are immutable
 A database file never shrinks