Thursday, September 30, 2010

Is oracle creating an index when we create a primary key?

Yes. In oracle 9i and Oracle 10g if you mention
primary key constraint in the create table statement
oracle Automatically creating an index with same
name as constraint

Ex;SY0023456

No comments:

Post a Comment