Indexes
A database index is a structure that is used to speed up locating and accessing operations in a database table. By using indexes, you decrease the number of disk accesses that are required when a query is processed. You can create indexes for one or more columns of a database table.
Create an index
In the Database tool window (), expand the data source tree until the node of a column.
Right-click a table or a column and select .
In the Columns pane, click the Add button (
).In the Name field, specify the name of the column that you want to add to the index.
Click Execute.
Productivity tips
Modify templates for generated index and key names
When you create indexes, and primary and foreign key constraints, their default names are generated according to corresponding templates. For a primary key, for example, the template is {table}_{columns}_pk.
To view and modify these templates, open the settings ⌃ ⌥ S and navigate to . Click the Code Generation tab.
The templates can contain variables and text. When you generate a name, the specified text is reproduced literally. For example, when you apply the
{table}_pktemplate in theactortable, the generated name of the primary key will beactor_pk.To see information about variables and their usage, click a field and press ⌃ Q.
{unique?u:}checks if the index is unique and inserts the corresponding sequence of characters. If the index is unique, the template generates a name with the sequence of characters specified between?and:. For the{unique?u:}template, it isu. If the index is not unique, the sequence between:and}is inserted. For the{unique?u:}template, it is nothing.Example
You have the
personstable with columnsFirstNameandLastName. The{table}_{columns}_{unique?u:}indextemplate generates the following name for the not unique index:persons_FirstName_LastName_index.