title: Is PARTITION RANGE ALL in your explain plan bad?
body: <p>Here's my explain plan:</p>
  
  <pre><code>SELECT STATEMENT, GOAL = ALL_ROWS   244492 4525870 235345240
   SORT ORDER BY   244492 4525870 235345240
    **PARTITION RANGE ALL**   207633 4525870 235345240
     INDEX FAST FULL SCAN MCT MCT_PLANNED_CT_PK 207633 4525870 235345240
  </code></pre>
  
  <p>Just wondering if this is the best optimized plan for querying huge partitioned tables.</p>
  
  <p><em>Using Oracle10g</em></p>