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: does unique constraints hurt insert performance

Re: does unique constraints hurt insert performance

From: Ana C. Dent <anacedent_at_hotmail.com>
Date: Sun, 13 Aug 2006 15:58:16 GMT
Message-ID: <Xns981E5B43060F4anacedenthotmailcom@70.169.32.36> 





"sunh11373" <sunh11373_at_gmail.com> wrote in
news:1155446530.659077.134280_at_m73g2000cwd.googlegroups.com: 



> 

> Duplicate data is not allowed. If dected, the insert should fail. If

> the "unique constrain" approach does not work, then the caller has to

> ensure the uniqueness before calling the database.




Do NOT top post.



How much overhead is incurred to "ensure the uniqueness before calling the 
database." as oppsed to letting the Unique constraint do the same thing?
Received on Sun Aug 13 2006 - 10:58:16 CDT












Original text of this message













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