Home » SQL & PL/SQL » SQL & PL/SQL » Constraint creates index?
Constraint creates index? [message #2343] Mon, 08 July 2002 10:05 Go to next message
Matthew Iskra
Messages: 16
Registered: April 2002
Location: Sacramento CA USA
Junior Member
I am a DBA that constantly switches between Oracle, Informix, and SQL Server. This sometimes makes me forget basic stuff, like the following.

When declaring constraints such as a primary key does oracle automatically build an index, or do I have to explicitly build an index for that primary key?

--Matthew

Report message to a moderator

Re: Constraint creates index? [message #2344 is a reply to message #2343] Mon, 08 July 2002 10:28 Go to previous messageGo to next message
Todd Barry
Messages: 4819
Registered: August 2001
Senior Member
Oracle will build an index if there is no existing unique or even non-unique index that it can use instead.

Report message to a moderator

Re: Constraint creates index? [message #2706 is a reply to message #2343] Wed, 07 August 2002 09:08 Go to previous message
Aaron
Messages: 13
Registered: January 2002
Junior Member
Oracle will automatically build an index on the primary key of any table

Report message to a moderator

Previous Topic: week of year calc
Next Topic: SET ECHO OFF, SET VERIFY OFF
Goto Forum:
  

[ Syndicate this forum (XML) ] [ RSS ]

Current Time: Fri Apr 19 07:07:54 CDT 2024
.:: Forum Home :: Blogger Home :: Wiki Home :: Contact :: Privacy ::.