Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> Re: Can Check Constraints be Reused for Multiple Columns?

Re: Can Check Constraints be Reused for Multiple Columns?

From: Sybrand Bakker <postbus_at_sybrandb.demon.nl>
Date: Tue, 09 Aug 2005 08:06:37 +0200
Message-ID: <3thgf1pk0i1eml9qktso0u1412tvhrpe7u@4ax.com> 





On Mon, 8 Aug 2005 16:48:26 -0700, "Andreas Sheriff"
<spamcontrol_at_iion.com> wrote:



>Hey guys.  Why so complex?  Won't a simple foreign key constraint do?

>

>-- 




A *foreign key* constraint? To a table containing only Y and N?
That would be causing I/O for every individual check.
I don't think you want that.



--
Sybrand Bakker, Senior Oracle DBA


Received on Tue Aug 09 2005 - 01:06:37 CDT












Original text of this message













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