Re: newbie question

From: <linjingjing_at_yahoo.com>
Date: Fri, 28 May 1999 19:08:25 GMT
Message-ID: <7impj7$q0$1@nnrp1.deja.com>

Hi, Ramana,

Indexes can be created in any tablespace. An index can be created in the same or different tablespace as the table it indexes. If you use the same tablespace for a table and its index, then database maintenance may be more convenient (such as tablespace or file backup and application availability or update) and all the related data will always be online together.
Using different tablespaces (on different disks) for a table and its index produces better performance than storing the table and index in the same tablespace, due to reduced disk contention. Here is an example to create index:
CREATE INDEX emp_ename ON emp(ename)

      TABLESPACE users
      STORAGE (INITIAL 20K
      NEXT 20k
      PCTINCREASE 75)
      PCTFREE 0;

Hope it helps.

Lin
MCSD Sent via Deja.com http://www.deja.com/
Share what you know. Learn what you don't. Received on Fri May 28 1999 - 14:08:25 CDT