Results 1 to 3 of 3
  1. #1
    Join Date
    Feb 2005
    Location
    India
    Posts
    217

    Unanswered: PK and Sort order

    In sql server when you create a PK on a table the data will be sorted physically.That means the logical and physical sort for the table is same.

    Is it the same case in Oracle?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    Provided Answers: 1
    No. Adding a primary key has no effect on the physical ordering of the data (except in Index-Organized Tables (IOTs)).

  3. #3
    Join Date
    Feb 2005
    Location
    India
    Posts
    217
    Thank you!

Posting Permissions

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