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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » UltraLite Database Settings Reference » Configurable properties in UltraLite

UltraLite fips property Next Page

UltraLite max_hash_size property


Sets the maximum default index hash size in bytes. UltraLite only uses as many bytes as required for the data type(s) of the column(s), up to this maximum.

How to set it

UltraLite employs different methods for setting this property:

ContextImplemented by

From the command line    Use any utility that creates a database.

Use the following property syntax:

-o max_hash_size=value

From Sybase Central    Use any wizard that creates a database.

On the New Database Storage Settings page, select the Maximum Hash Size for Indexes option .

From a client application    Use the create database method.

Set this property as one of the creation parameters for an API's create database method on the database manager class.

Allowed values

0 to 32 bytes

Default

4 bytes

Remarks

The default hash size is only used if you do not set a size when you create the index.

If you set the default hash size to 0, the does not hash row values.

You cannot change the hash size for an index after the index has been created. You can, however, override the default when you create a new index with the UltraLite Create Index wizard in Sybase Central, or with the WITH MAX SIZE clause in a CREATE INDEX or a CREATE TABLE statement.

If you declare your columns as DOUBLE, FLOAT, or REAL data types, no hashing is used. The hash size is always ignored.

See also