Re: Index on different tablespace
From: Don Brown <don_at_rl.gov>
Date: 1996/01/23
Message-ID: <4e3s2m$lcl_at_columbia>#1/1
Date: 1996/01/23
Message-ID: <4e3s2m$lcl_at_columbia>#1/1
In article 1c3_at_portal.gmu.edu, dnguyeb_at_site.gmu.edu (Dong Nguyen (INFT801)) writes:
> Hello,
> I have heard that indexes are read faster if stored in different
> table space. Is this true. If so why?
>
> Doug g
It's true if the index tablespace is made up of files on a disk other than where the tablespace the tables being indexed reside in. This is true because it reduces disk contention.
At least that's the way I understand it,
Don
Boeing Computer Services, Richland
(509) 376-6990
don_brown_at_rl.gov
Received on Tue Jan 23 1996 - 00:00:00 CET