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: CBO choose full table scan, not index

Re: CBO choose full table scan, not index

From: lsllcm <lsllcm_at_gmail.com>
Date: Tue, 27 Nov 2007 22:26:27 -0800 (PST)
Message-ID: <d819bdae-b152-4359-a89a-b61b4a36f3ed@a39g2000pre.googlegroups.com> 





Thank you, I will do more read on it,



But using index is faster than full table scan, but the cost of index
is high full table scan.
Received on Wed Nov 28 2007 - 00:26:27 CST












Original text of this message













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