From: eugene kim <eugene1977@hotmail.com>
Newsgroups: comp.databases.oracle.server
Subject: Re: constraint question
Date: Mon, 09 Sep 2002 12:42:09 +0000
Organization: Mailgate.ORG Server - http://www.Mailgate.ORG
Lines: 14
Sender: yoyoeugenekim@hotmail.com
Message-ID: <alhbip$pok$1@newsreader.mailgate.org>
References: <alfu81$3vd$1@newsreader.mailgate.org> <uno9qpk0alj55a@corp.supernews.com>
NNTP-Posting-Host: cs24162112-122.hot.rr.com
Mime-Version: 1.0
Content-Type: text/plain; charset=us-ascii
Content-Transfer-Encoding: 7Bit
X-Trace: newsreader.mailgate.org 1031549337 26388 24.162.112.122 (9 Sep 2002 05:28:57 GMT)
X-Complaints-To: abuse@mailgate.org
NNTP-Posting-Date: Mon, 9 Sep 2002 05:28:57 +0000 (UTC)
User-Agent: KNode/0.7.1


thanks for helps..

but then 
is it a good idea to have unique constraint for all columns for each table

table1 has col1,col2,col3
then have unique (col1, col2, col3) constraint
table2 has t_col1, t_col2
and have unique (t_col1, t_col2) constraint
and so on ..

?

thank you