When to Create Indexes

[Former Member]

When creating indexes, is it necessary to explicitly define them on Foreign, Primary, and Alternate Keys or are they created by default because of the key?

[VolkerBarth · Accepted solution]

From the SA 10.0.1 docs:

Keys and unique columns

SQL Anywhere automatically creates indexes on primary keys, foreign keys, and unique columns. You should not create additional indexes on these columns. The exception is composite keys, which can sometimes be enhanced with additional indexes.

I guess that pretty says it all.