At 05:15 a.m. 28/06/2015, Adriano dos Santos Fernandes wrote:
>On 27-06-2015 04:19, Jiří Činčura wrote: >> Just a way to store the order 
>you passed. > > I know it doesn't matter now, but is there a reason to store 
>the order? > 


>Extract the metadata in the same way it was created, I guess. Adriano 

This question makes me curious as to whether INSERT OR UPDATE and UPDATE OR 
INSERT are actually processed in exactly the same way, or does the order affect 
the execution logic?

i.e., if INSERT is the first operator, does the engine attempt INSERT and 
perform UPDATE if the key is found...if UPDATE is first, does the engine 
attempt UPDATE and perform INSERT if the key is not found?

Helen



------------------------------------------------------------------------------
Monitor 25 network devices or servers for free with OpManager!
OpManager is web-based network management software that monitors 
network devices and physical & virtual servers, alerts via email & sms 
for fault. Monitor 25 devices for free with no restriction. Download now
http://ad.doubleclick.net/ddm/clk/292181274;119417398;o
Firebird-Devel mailing list, web interface at 
https://lists.sourceforge.net/lists/listinfo/firebird-devel

Reply via email to