title: where rownum=1 query taking time in Oracle
body: <p>I am trying to execute a query like </p>
  
  <pre><code>select * from tableName where rownum=1
  </code></pre>
  
  <p>This query is basically to fetch the column names of the table.There are more than million records in the table.When I put the above condition its taking so much time to fetch the first row.Is there any alternate   to get the first row.</p>