You can view details about 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 whose details you want to see, and select Open Index.
The property form displays the details for the join or hash index.