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

SAP Sybase SQL Anywhere 16.0 » UltraLite - Database Management and Reference » UltraLite database schemas » UltraLite indexes


Adding an UltraLite index

Adding indexes to databases speeds up the search process.


The database must be connected.

Context and remarks


UltraLite does not detect duplicate or redundant indexes. As indexes must be maintained with the data in your database, add your indexes carefully.

  1. Using Sybase Central, connect to the UltraLite database.

  2. Right-click Indexes, and click New » Index.

  3. Follow the instructions in the wizard.


The index is created.


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)

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 also