|
You can set the maximum hash size in two ways:
To store a database default for the maximum size, you can set a database property called max_hash_size 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 set with this parameter, you can set a specific hash size when you create a new index. You can do this in two ways:
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.