Re: create index when add primary key

From: Murthy Patamalla <Murthy.Patamalla_at_vanadium.brooks.af.mil>
Date: 1996/06/27
Message-ID: <4qut97$llu_at_xenon.brooks.af.mil>#1/1

The answer is YESSSSSSSSSSSSSSSS!

While creating tables create a constraint as below:

      CONSTRAINT indexname PRIMARY KEY(Field/s) 
        USING INDEX   PCTFREE xx 
           TABLESPACE tablespacename 
        STORAGE ( xxxxxxxxxx)

This will put the specific index in the tablespace specified. Let me know, if you have any questions. Received on Thu Jun 27 1996 - 00:00:00 CEST