Creating an Index

To create an index:
  1. Go to the Schema Manager page in InformixHQ.
  2. Select the table.
  3. Click … and – Select Create Index
  4. Enter the required details.
  5. Click the View SQL button to review the SQL statement.
  6. Click the Create button, index will be created.
Note: You can also enable or disable the index.