You can choose to remove all indexes from some tables.
Dropping indexes means deleting indexes from a table
together with all the data stored in the indexes.
-
In the left pane, click Tables.
-
From the Tables list in the right pane, select the tables whose indexes you
want to remove.
Press SHIFT and click to select consecutive tables or
press CTRL and click to select multiple tables.
-
Right-click on a highlighted table and click Drop
Indexes.
A message appears asking you to confirm if you want to remove all
indexes from all the selected tables.
-
Click Yes.