SQLEditor Icon

Create a multi-column Index

  1. Click on the table you want to add the index to
  2. Choose ObjectAdd Index. A new index entry will appear in the table
  3. Move to the inspector and look at the list of columns
  4. Tick the checkbox for each column that you wish to include
You can drag the columns to reorder the way they appear in the index