When you forward-engineer your model to generate a database schema, a separate index is automatically created on the primary key of each table, as well as on all alternate keys, foreign keys, and inversion entries, since these columns are most frequently used to search for data. You can use any of the automatically generated indexes to easily create indexes as your business requirements change. You can also create indexes for views. When you create an index, you can assign different columns to it, and you can change the index properties of your particular database applications.
| Copyright © 2009 CA. All rights reserved. | Email CA about this topic |