New Index

New indexes are generated via the selection of the corresponding table columns. If the index name is displayed (below), an index for all selected fields will be specified, otherwise an index with the name 'IDX_Fieldname' for every selected field.

After confirmation of the dialog with Ok, here the following SQL statements are returned: CREATE INDEX IDX_Country ON customer (Country) CREATE INDEX IDX_Phone ON customer (Phone) CREATE INDEX IDX_FAX ON customer (FAX) CREATE INDEX IDX_Contact ON customer (Contact)

<< Back