title: Tuning of query with ALL_OBJECTS view
body: <p>I need help in tuning following query involving querying from Oracle data dictionary ALL_OBJECTS.</p>
  
  <pre><code>SELECT OBJECT_NAME ,OBJECT_TYPE 
  FROM ALL_OBJECTS OBJ 
  WHERE (OBJ.OWNER ='HR') 
  AND (OBJ.OBJECT_TYPE IN ('TABLE','VIEW'));
  </code></pre>
  
  <p>I tried tuning query using hint as following but not much of help.</p>
  
  <pre><code>SELECT /*+ STAR_TRANSFORMATION */ OBJECT_NAME
         ,OBJECT_TYPE 
  FROM ALL_OBJECTS OBJ 
  WHERE (OBJ.OWNER ='HR') 
  AND (OBJ.OBJECT_TYPE IN ('TABLE','VIEW'));
  </code></pre>
  
  <p>Any help will be highly appreciated.Thanks a lot.</p>