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: Fragmented vs. Contiguous vs. Single-extent segments

Re: Fragmented vs. Contiguous vs. Single-extent segments

From: Martin Haltmayer <Martin.Haltmayer_at_0800-einwahl.de>
Date: Sat, 14 Apr 2001 19:31:16 +0200
Message-ID: <3AD88964.57BDF591@0800-einwahl.de> 






If you access a table by indexes you will do accesses of type "few rows at once"
which not be hindered by fragmentation. So I never experienced performance
degradation on fragmented tables when acessing the data by indexes.



Martin
Received on Sat Apr 14 2001 - 12:31:16 CDT












Original text of this message













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