select ixt.owner, ixt.indextype_name, ixt.implementation_schema, ixt.implementation_name, ixt.number_of_operators, typ.typecode, typ.type_oid, ixt.partitioning, ixt.array_dml, ixt.maintenance_type, ixt.interface_version, ixt.implementation_version from dba_indextypes ixt left join dba_types typ on ixt.implementation_schema = typ.owner and ixt.implementation_name = typ.type_name ;