Re: Help !!! Indexes and Tablespace Question

In <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.
>
>--
>*******************************************
>-Rajasekaran Rangarajan
>-Administrative Progamming Services
>-Clemson University
>-Email: raj_at_cs.clemson.edu
>

We found that it was a performance boost to have a separate tablespace for your indexes if you make sure that the table's data file is on one disk and the index file is on another disk. (That way the hardware could be doing two simultaneous writes.

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