The Index Editor allows you to add indexes to your table. Adding indexes can significantly speed up
queries if done correctly. Indexes can also slow down a query if there are to many of them.
Also adding new indexes to existing tables can be very slow depending on the CPU(s) the server has.
The index name is generated for you using the table name postfixed with idx and an number.
The number is 1 + the total number of existing indexes for the table.
To add columns you simply have to check them off. |
||
|
|
See also: