Re: separate tablespaces for tables and indexes
- From: Jared Still <jkstill@xxxxxxxxx>
- To: thomas.mercadante@xxxxxxxxxxxxxxxxx
- Date: Mon, 13 Dec 2004 11:30:18 -0800
On Mon, 13 Dec 2004 14:15:06 -0500, Mercadante, Thomas F
<thomas.mercadante@xxxxxxxxxxxxxxxxx> wrote:
> Jeff,
>
> In my view, separating indexes and tables was never about tablespace
> contention. It was always about moving the index and table files onto
> separate disk drives to avoid disk contention.
>
Hi Tom,
Separating Tables from Indexes is good for managing different types of objects.
How would separating them enhance performance?
In a multi-user system with several sessions selecting, inserting, deleting and
modifying data, separating the indexes from the tables would not seem to
have any performance benefit.
Even if there is only one user on the system, indexes must be read before
the table is read ( if the table is read at all). They aren't
actually in contention.
--
Jared Still
Certifiable Oracle DBA and Part Time Perl Evangelist
--
//www.freelists.org/webpage/oracle-l
Other related posts:
