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

SQL Anywhere 10.0.1 » UltraLite - Database Management and Reference » Working with UltraLite Databases » Working with UltraLite indexes

When to use an index Next Page

Choosing an index type

UltraLite supports different types of indexes: unique keys, unique indexes and non-unique indexes. What differentiates one from the others is what is allowed in that index.

Index characteristicUnique keysUnique indexesNon-unique indexes
Allows duplicate index entries for rows that have the same values in indexed columns.nonoyes
Allows null values in index columns.noyesyes

You can create foreign keys to unique keys, but not to unique indexes.

Also, manually creating an index on a key column is not necessary and generally not recommended. UltraLite creates and maintains indexes for unique keys automatically.

See also