You can drop a join or hash index.
- In the Navigator, click the Databases category.
- Right-click a database or user and select Show Database Indexes. A list of the join and hash indexes in the connected system appears in the Object List Viewer. The list is filtered according to any filters you have applied.
- Right-click the index you want to drop, and select Drop Index.
- Click OK to confirm.