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.
| Discuss this page in DocCommentXchange. Send feedback about this page using email. |
Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1 |