Re: Help !!! Indexes and Tablespace Question

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

Different tablespaces doesn't help much unless each tablespace is on a different device.

-- 
********************************************************************************
David Stark           stark_at_greenwich.com      (203)625-5066
Greenwich Associates  8 Greenwich Office Park  Greenwich CT  06831-5195