Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Why Statistics doesn't match reponse time?

Re: Why Statistics doesn't match reponse time?

From: Bin <wangbinlxx_at_gmail.com>
Date: 11 Sep 2005 23:32:54 -0700
Message-ID: <1126506774.536558.3830@g14g2000cwa.googlegroups.com> 





>His hint causes the optimizer to do the index full scan, instead of the full table scan.

Not index full scan, it 's index range scan.
INDEX (RANGE SCAN) OF 'TOTAL_CONTRIBUTIONLOG_IDX'

(NON-UNIQUE) (Cost=1 Card=1044)



Regards,


Bin
Received on Mon Sep 12 2005 - 01:32:54 CDT












Original text of this message













  HOME |
  ASK QUESTION |
  ADD INFO |
  SEARCH |
  E-MAIL US