Re: Enough of the "DB2" thread, let's talk about Fragmented Tables

From: DA Morgan <damorgan@xxxxxxxxx>
Date: Fri, 29 Jul 2005 18:03:58 -0700

Bill Dare wrote:

	I don't think it matters what type of storage device you are
using, you will still get better performance if you fragment your data
accross all available physical devices.  By physical devices I mean the
actual disk drives.  In a SAN that would probably be a group of drives
configured RAID5/RAID10.

Bill


I agree. That has been my experience with every commercial RDBMS.
--
Daniel A. Morgan
http://www.psoug.org
damorgan@xxxxxxxxxxxxxxxx
(replace x with u to respond)
.

References:
- RE: Enough of the "DB2" thread, let's talk about Fragmented Tables
  - From: Bill Dare

Prev by Date: Re: Change chunk name
Next by Date: Re: No future for DB2
Previous by thread: RE: Enough of the "DB2" thread, let's talk about Fragmented Tables
Next by thread: Re: Enough of the "DB2" thread, let's talk about Fragmented Tables
Index(es):
- Date
- Thread