You can use either Sybase Central or Interactive SQL to perform this task.
UltraLite does not detect duplicate or redundant indexes. As indexes must be maintained with the data in your database, add your indexes carefully.
In Sybase Central, you can perform this task while working with a selected database.
Connect to the UltraLite database.
Right-click Indexes, and choose New » Index.
Follow the instructions in the wizard.
In Interactive SQL, you can perform this task with the CREATE INDEX statement.
Connect to an UltraLite database.
Execute a CREATE INDEX statement.
This statement creates an index with the default maximum hash size you have configured. To create an index that overrides the default, ensure you use the WITH MAX HASH SIZE value clause to set a new value for this index instance. See UltraLite CREATE INDEX statement.
For example, to speed up a search on employee surnames in a database that tracks employee information, and tune the performance of queries against this index, you could create an index called EmployeeNames and increase the hash size to 20 bytes with the following statement:
CREATE INDEX EmployeeNames ON Employees (Surname, GivenName) WITH MAX HASH SIZE 20;
|Discuss this page in DocCommentXchange.
Send feedback about this page using email.
|Copyright © 2009, iAnywhere Solutions, Inc. - SQL Anywhere 11.0.1|