Does Upsert statement executes on data set in order

Asked Jan 23 '14 at 08:47

Active Jan 23 '14 at 09:15

Viewed 415 times

There are two columns in Database Table (Key and TimeStamp).

Lets assume, there are three rows in the data set with same Key but with different timestamp. The dataset is sorted based on Timestamp.

If the Upsert on the table is executed on this data set, will the last row(with latest timestamp - because of order by) be there in the database table or the execution order is not guaranteed?

edited Jan 23 '14 at 09:15

asked Jan 23 '14 at 08:47

Kumar

1,536
2
23
33

What you want to do exactly? – Damith Jan 23 '14 at 08:54
@Damith: I want to upsert the record with latest timestamp. – Kumar Jan 23 '14 at 08:56
"*The data in table is sorted*" - no, it's not. Data in a relational database is ***NOT SORTED***. Also please specify which DBMS you are using. Postgres? Oracle? – Jan 23 '14 at 09:10
I meant the data in the dataset is sorted. Sorry for the confusion. I am on SAP HANA – Kumar Jan 23 '14 at 09:16

Does Upsert statement executes on data set in order

0 Answers0