Path: newssvr20.news.prodigy.com!newsmst01.news.prodigy.com!prodigy.com!prodigy.com!pd2nf1so.cg.shawcable.net!residential.shaw.ca!sn-xit-03!sn-xit-01!sn-post-01!supernews.com!corp.supernews.com!not-for-mail
From: cschang <cschang@maxinter.net>
Newsgroups: comp.databases.oracle.misc
Subject: What makes difference by creating an index or add a primary key to a 
 table
Date: Fri, 08 Aug 2003 22:43:58 -0400
Organization: Posted via Supernews, http://www.supernews.com
Message-ID: <3F345FEE.B9622EBF@maxinter.net>
X-Mailer: Mozilla 4.77 [en] (Win98; U)
X-Accept-Language: zh-TW,en,zh
MIME-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7bit
X-Complaints-To: abuse@supernews.com
Lines: 9
Xref: newssvr20.news.prodigy.com comp.databases.oracle.misc:130395

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