You can view details about a join or hash index. In the Navigator, expand Databases, right-click a database or user, and select Show Database Indexes. In Object List Viewer, double-click the index you want to view.