Oracle FAQ | Your Portal to the Oracle Knowledge Grid |
Home -> Community -> Usenet -> c.d.o.server -> select + insert vs. insert and catching exception
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