title: Tuning table select SQL having a RAW column in Oracle 10g
body: <p>I have a table with several columns and a unique RAW column. I created an unique index on the RAW column.</p>
  
  <p>My query selects all columns from the table (6 million rows).</p>
  
  <p>when i see the cost of the query its too high (51K). and its still using INDEX FULL scan. The query do not have any filter conditions, its a plain select * from.</p>
  
  <p>Please suggest how can i tune the query operation.</p>
  
  <p>Thanks in advance.</p>