Defining a Default Value for a Physical Option

A physical option can have a default value specified by the Default= x keyword, which is placed after the option name or after the %d or %s value, and separated by a colon.

Example

The default value for max_row_per_page is 0. In Sybase Adaptive ServerĀ® Enterprise 11, this default value for the index object is defined as follows:

max_rows_per_page=%d : default=0