Re: Help !!! Indexes and Tablespace Question

From: Kasten10 <kasten10_at_aol.com>
Date: 1995/10/04
Message-ID: <44uvn2$5a9_at_newsbf02.news.aol.com>#1/1


In article <44u9vo$cmk_at_hubcap.clemson.edu>, raj_at_cs.clemson.edu (Rajasekaran Rangarajan) writes:

>Hi,
> Does anyone know if there is any advantage by having the
>indexes on tables created in a separate table space (not having the
>table and indexes on the table occupy the same table_space). We are
>specifically interested in knowing if this is going to improve/worsen
>the performance of queries on these tables -we have a situation in
>which a number of our tables get updated nightly resulting in index
>unbalancing( the best way would be to rebuild the indexes I guess) but
>wanted to know if any benefits can be got by moving the indexes to
>their own table_space
> please post your replies here and/or send to raj_at_cs.clemson.edu
>
>Thanks in advance.
>

I think I can safely state that one should *always* have the tables and indexes in different table spaces if at all possible. The i/o advantage alone is obvious...

Chris Kasten
P/A Received on Wed Oct 04 1995 - 00:00:00 CET

Original text of this message