Oracle FAQ

Your Portal to the Oracle Knowledge Grid

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US

Home -> Community -> Usenet -> c.d.o.misc -> Re: What makes difference by creating an index or add a primary key to a table

Re: What makes difference by creating an index or add a primary key to a table

From: DJ <nospamplease_at_goaway.com>
Date: Sat, 9 Aug 2003 10:20:42 +0100
Message-ID: <K13Za.8380$yl6.4995@newsfep4-winn.server.ntli.net>

"cschang" <cschang_at_maxinter.net> wrote in message news:3F345FEE.B9622EBF_at_maxinter.net...
> System: 8.1.7
> Platform: NT 4 w/sp6a
> I have a table that I decided to add a primary key by combining two
> columns. But what that difference to create an index of the table by
> using these two columns?
>
> C Chang
>
>

by using a primary key you are adding a constraint as well. With an index you dont get that Received on Sat Aug 09 2003 - 04:20:42 CDT

This message: [ Message body ]
Next message: Rainer Hahnekamp: "recordset from ms-sql stored procedure"
Previous message: Jusung Yang: "Re: Errors from create Materialized View"
In reply to: cschang: "What makes difference by creating an index or add a primary key to a table"
Next in thread: Daniel Morgan: "Re: What makes difference by creating an index or add a primary key to a table"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US