Opening indexes
On Database view tap on any index in the list, Index view containing the selected index will pop.
Creating indexes
On Database view tap "New Index" button, Index view will pop.
Tap "Edit script", a Script Editor view will pop. Read more in "Script editor".
After you wrote a script defining the index tap "Test script". If script is incorrect correct it.
Finally tap "Save" button.
Deleting indexes
On Database view tap on "Edit" button, then select indexes you want to delete, finally tap on "Done" button.
Editing script
Tap "Edit script", a Script Editor view will pop. Read more in "Script editor".
After you wrote a script defining the index tap "Test script". If script is incorrect correct it.
Finally tap "Save" button.