Re: I don't know the difference of using index clause and just constraint clause

"Bonjour" from Paris

When you use the USING INDEX clause, you specifie parameters for the index :

- physical attributes
- sorting choice
- logging/nologging
- tablespace

"Au revoir" from Paris.

Christophe Brault

Victor Min a écrit :

> Hi.. there..
> I don't know the difference of 'using index' clause and just primary
> key constraint...
>
> detail...
> 1.Create Table testtable(
> test number(4) constraint ...primary key
> using index ....
> ...)
> =>create a unique index for primary key...(it's explicit)
> 2.Create Table testtable(
> test number(4) constraint ... primary key
> ..)=>create a unique index for primary key...(it's implicit & not
> use 'using index clause)
>
> pls..let's me know the difference of No.1 and No.2
Received on Fri Aug 17 2001 - 09:06:46 CDT