Help !!! Indexes and Tablespace Question
From: Rajasekaran Rangarajan <raj_at_cs.clemson.edu>
Date: 1995/10/04
Message-ID: <44u9vo$cmk_at_hubcap.clemson.edu>#1/1
-Rajasekaran Rangarajan
-Administrative Progamming Services
-Clemson University
-Email: raj_at_cs.clemson.edu
Received on Wed Oct 04 1995 - 00:00:00 CET
Date: 1995/10/04
Message-ID: <44u9vo$cmk_at_hubcap.clemson.edu>#1/1
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
Received on Wed Oct 04 1995 - 00:00:00 CET