title: Oracle SQL - check missing indexes on SQL query
body: <p>I need to check if in a query, index or indexes are missing.</p>
  
  <p>For check indexes in a table I use syntax:</p>
  
  <pre><code>SELECT index_name
       , column_position
       , column_name
    FROM user_ind_columns
   WHERE table_name = 'table_name'
   ORDER BY index_name, COLUMN_POSITION;
  
   SELECT index_name 
   FROM user_indexes
   WHERE table_name = 'table_name';
  </code></pre>
  
  <p>It is possible to use a program or SQL script to find automatically if is missing indexes on a query and show it for creation them?</p>
  
  <p>Thanks!</p>