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

SQL Anywhere 12.0.0 » UltraLite - Database Management and Reference » Using UltraLite databases » UltraLite performance and optimization


Setting the maximum hash size

You can set the maximum hash size in two ways:

  • To store a database default for the maximum size, you can set the max_hash_size creation parameter when you create your database. If you do not want to hash indexes by default, set this value to 0. Otherwise, you can change it to any value up to 32 bytes, or keep the UltraLite default of 4 bytes.

  • If you want to override the default, you can set a specific hash size when you create a new index. Do one of the following:

    • In Sybase Central, set the Maximum Hash Size property when creating a new index.

    • With SQL, use the WITH MAX HASH SIZE clause in either the CREATE TABLE or CREATE INDEX statement.

 See also