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: Performance degradation

Re: Performance degradation

From: hpuxrac <johnbhurley_at_sbcglobal.net>
Date: 14 Apr 2005 07:03:11 -0700
Message-ID: <1113487391.633541.102490@o13g2000cwo.googlegroups.com> 





> All I'm asking is why full table scan on large table can cause

> performance degradation in Oracle.




When oracle does a full table scan it reads thru every block.  The
bigger the table the more blocks it has to process.



It is much slower doing this if you are selecting just a few of the
records then retrievals against an index.
Received on Thu Apr 14 2005 - 09:03:11 CDT












Original text of this message













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