Re: Index on different tablespace

From: Bob Blizard <rblizard_at_bb.cmcsys.com>
Date: 1996/01/24
Message-ID: <4e5jsg$fir_at_caesar.ultra.net>#1/1

Yes, this is generally true if the tablespaces are on separate disks. By storing indexes in separate tablespaces/disks, you reduce contention for the disks. In addition, your tablespaces may also remain somewhat less fragmented by separating them.

dnguyeb_at_site.gmu.edu (Dong Nguyen (INFT801)) wrote:

> Hello,
> I have heard that indexes are read faster if stored in different
>table space. Is this true. If so why?
>
> Doug g

Bob Blizard rblizard_at_bb.cmcsys.com | All these worthwhile

CMC Systems, Inc.                      | opinions are mine, and

175 Littleton Rd Westford, MA 01886 | not necessarily CMC's... Ph (508) 392-1300 Fax (508) 392-1303 | "If you want to park in the first row of life, you must go there first." Received on Wed Jan 24 1996 - 00:00:00 CET