Re: Manual Index Creation

When you have an unique index on an table, and you define a primary key contstraint using the same
columns as the index, the index will be used for the constraint.

If you want to tell where to put the index from the primary key constraint use :

	create ....
	using index tablespace <MyIndextableSpace>

Gert

khinkle_at_indcompsrc.com wrote in article <7h7c7b$fmb$1_at_nnrp1.deja.com>...
> I'm still pretty new to Oracle. I keep hearing that I should be creating
> my indexes in a separate tablespace. Is this a religious issue, and if
> so can I hear arguments for and against?
>
> I can see how doing this might give me more flexibility for I/O tuning
> later on, if I wanted to move the datafile to another set of disks...is
> that the primary reason for doing this?
>
> My main question relates to the indexes Oracle automatically creates
> when you specify a primary key or unique constraint. Is there a standard
> procedure for "replacing" the auto-generated index with a manually
> created one?
>
> Is there any problem with the following:
>
> 1) Create table with primary key
> 2) Alter table disable primary key
> 3) Create index on the pk column in the different tablespace
> 4) Alter table enable primary key
>
> Does disabling the primary key constraint drop the auto-generated
> index, or should that be another step?
>
> Any gotchas I should watch out for?
>
>
> --== Sent via Deja.com http://www.deja.com/ ==--
> ---Share what you know. Learn what you don't.---
>
Received on Mon May 10 1999 - 14:53:05 CDT