Re: Basic: Index on Primary Key

On Thu, 28 Mar 2002, pmohanan_at_directvinternet.com wrote:

> This might be a basic question. As far as I have learned, we
> should first create an Index(es) on the column(s) identified as
> primary key of a table. Then alter the table to create the primary
> key, so that the Key automatically uses the index instead of
> creating its own index in the system tablespace. How much of this
> is true?

You've gotten the main answers, but from your question, the default tablespace of the creator of the primary key is system. This is bad and should be changed as well.

-- 
Galen deForest Boyer
Sweet dreams and flying machines in pieces on the ground.