Re: Indexes part II

1 Yes, but they will be located in the same tablespace as the table. You need to add
using index tablespace <tablespace_name> etc.
to make sure they end up in a different tablespace

2
There is no syntax to combine adding a foreign key and an index at the same time.
This will be a separate command.
The order is unimportant,ie theoretically you could create the index first and then issue your alter table.

Hth,

--
Sybrand Bakker, Oracle DBA
Cherk <andrija.cerkez_at_lijanovici.com> wrote in message news:81b63n$o53$1_at_as102.tel.hr...
> Thank's Sybrand Bakker !
>
> I have additional questions.
>
> 1. Is it true:
>
> "When I defined primary and unique key in Oracle 7, indexes on them
> is immediatly created"
>
> 2. May I define index on foreign key immediatly when I created table and
> defined foreign constraint, or I need to do this after with statement
Create
> index ...
>
>
> --------------------------------------------------------------------------
--
> --------------
> I have the simplest tastes. I am always satisfied with the best.
> --------------------------------------------------------------------------
--
> --------------
> Cherk (andrija.cerkez_at_lijanovici.com), Siroki Brijeg, Croatia
> Cherk's home page (http://www.angelfire.com/co/Cherk)
>
>
Received on Mon Nov 22 1999 - 05:56:37 CST