Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Posts
    370

    Question Unanswered: Does oracle create index for keys automatically?

    Hi all,
    Say I have done:
    Code:
    ALTER TABLE ADD CONSTRAINT table_pk PRIMARY KEY (id);
    Will it generate an index on id column implicitly?
    What for unique constraints?

    Thanks in advance..

  2. #2
    Join Date
    Nov 2003
    Posts
    2,934
    Provided Answers: 12
    Quote Originally Posted by Ach
    Will it generate an index on id column implicitly?
    What for unique constraints?
    Yes it will, see here
    Quote Originally Posted by Manual
    because Oracle Database creates an index on the columns of the unique or primary key in the schema containing the table

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •