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 -> select + insert vs. insert and catching exception

select + insert vs. insert and catching exception

From: Christoph Seidel <chris666.seidel_at_gmx.de>
Date: Thu, 26 Sep 2002 14:05:05 +0200
Message-ID: <amut5g$9edrd$1@ID-143718.news.dfncis.de>


what is better in respect of performance?

select by primary key, if not found insert

or

insert and catch exception if primary key exists

the table is quite small, less than 100 rows Received on Thu Sep 26 2002 - 07:05:05 CDT

Original text of this message

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