  SELECT a.object_name, a.operation, a.options, count(*)
    FROM dba_hist_sql_plan a, dba_hist_sqlstat b
   WHERE a.object_owner <> 'SYS' AND a.operation LIKE '%INDEX%'
         AND a.sql_id = b.sql_id
GROUP BY a.object_name, a.operation, a.options
ORDER BY 1,2,3