Re: fragmentation - a myth?

(1) You can analyze whatever you want if you : - Choose RULE in init.ora                                                                             

• If you build rule oriented Queries. (2) Unbalanced B* Tree's. Makes sense that you reorg (depending on queries)

(3) Analyzing objects to see Row Migration is a good ideia. Sometimes chaining can't be avoid.

(4) I don't call myself DBA

Jorge Meirim

>Has anyone done timings to see how much
>performance improves when they
>(1) re-analyze the table
>(2) rebuild the index
>(3) de-fragment the objects?
>
>I'm going to do some myself soon.
>
>I know theoretically you reduce head
>movement, etc, but I wonder how much that
>matters these days.
>
>Any results would be very appreciated.
>
>Thanks,
>
>Ben Krug, DBA
>benkrug_at_yahoo.com
>
>
>
>-----------== Posted via Deja News, The Discussion Network ==----------
>http://www.dejanews.com/ Search, Read, Discuss, or Start Your Own
Received on Mon Nov 16 1998 - 14:35:04 CST