Home » SQL & PL/SQL » SQL & PL/SQL » primary key then index necessary???
primary key then index necessary??? [message #4491] Sun, 15 December 2002 03:06 Go to next message
Paloo
Messages: 2
Registered: December 2002
Junior Member
I have created a table with a primary key. Do I also need to create an index at the same colomn? Or will Oracle automatically creates an index for my primary key colomn?

Report message to a moderator

Re: primary key then index necessary??? [message #4493 is a reply to message #4491] Sun, 15 December 2002 16:17 Go to previous message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Oracle will create an index to use in the enforcement of the constraint unless there already was an existing index with leading columns that matched the constraint definition.

Report message to a moderator

Previous Topic: primary key then index necessary?
Next Topic: change parameter of sqlplus from pl/sql procedure ?
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Thu May 16 03:57:31 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.