Index
Create index
You can find the index manager from the Table Structure view. To create a new index:
Open the table structure view (
⌘ + ^ + ]
)Click on the
+ Index
button at the bottom, or double click on the blank row under the index section, or use shortcut key⌘ + I
when selecting an index.Press
⌘ + S
to commit changes to the server.
Edit index
To edit an index:
Open the table structure view (
⌘ + ^ + ]
)Double click on index's attribute and edit inline
Press
⌘ + S
to commit changes to the server.
Delete index
Open the table structure view (
⌘ + ^ + ]
)Select the index and press Delete key, or right click and choose Delete.
Press
⌘ + S
to commit changes to the server.
Last updated