Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> I don't know the difference of using index clause and just constraint clause

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

From: Victor Min <victor_at_shinsegae.com>
Date: 16 Aug 2001 21:21:38 -0700
Message-ID: <d30a1319.0108162021.a40d2fa@posting.google.com>


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 Thu Aug 16 2001 - 23:21:38 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US