Creating an index

"Create Index" allows you to add an index to an existing table.

To create an index, select "Create" from the "Select" list. Choose "Index" from the next list and then select "ON". A list of tables within your database will be displayed, choose the table you want to create the index for. Enter the name of index in the "Index Name" textbox and select the column name you want to be used for indexing. If you want the entries for the indexed column to be unique click the "Unique" checkbox. Select the order in which you want to index your column, from the "Column Order" drop-down menu. Click the "Build SQL Query" button and after reviewing the SQL Query click on the "Run SQL Query" to complete the operation. The result of operation will appear at the bottom of the page.