Re: Help !!! Indexes and Tablespace Question

In article <44uvn2$5a9_at_newsbf02.news.aol.com>, kasten10_at_aol.com (Kasten10) 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

Oops! Allow me to clarify myself - The tablespaces should be on different storage devices... THEN the i/o advantage becomes obvious.

Chris Received on Thu Oct 05 1995 - 00:00:00 CET