Re: Help !!! Indexes and Tablespace Question

>
> Help !!! Indexes and Tablespace Question
>
> raj_at_cs.clemson.edu (Rajasekaran Rangarajan)
> 4 Oct 1995 15:41:44 GMT
> Clemson University
>
> Newsgroups:
> comp.databases.oracle
>
> 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

It depends on your platform. If you're running a Netware server version, it may not make any difference. On Mainframes, if you create your table and index tablespaces on different disk devices, you can get some advantage. If you distribute the work over two devices, then it speeds up the process. (You'll have to check with your SysOp for file/member names to use in the CREATE TABLESPACE statement.)

Good Luck!

    _   _  _ _  __    : Paul Roberts                 
   |_  |_|  |  |      : Programmer / Analyst        
    _| | | _|_ |__    : proberts_at_isc901.jsc.nasa.gov 

Scientific Applications International Corporation

   (An employee-owned company)

  The opinions expressed are my own, and not necessarily   the views of SAIC, NASA, or the U.S. government. Received on Fri Oct 06 1995 - 00:00:00 CET