does a primary key defines an Index?
Printable View
does a primary key defines an Index?
in 8i index is implicitly created
in 9i you can choose wheather create implicitly or explicitly
... although if a non-unique index already exists on the PK columns, it will be used to enforce the PK -- a unique index will not be created.Quote:
Originally posted by pando
in 8i index is implicitly created