Timeline for Retrieving changed rows only from a table with 10^7 rows
Current License: CC BY-SA 3.0
4 events
| when toggle format | what | by | license | comment | |
|---|---|---|---|---|---|
| Jan 25, 2016 at 8:58 | comment | added | awesoon | I've compared two queries, results: gist.github | |
| Jan 24, 2016 at 11:24 | comment | added | dnoeth |
I would be interested in performance difference between LAG and LATERAL JOIN, could you add some numbers? Btw, the ORDER BY in the Derived Table can be removed, too.
|
|
| Jan 24, 2016 at 9:20 | comment | added | awesoon |
Thank you for the answer! Yes, I definitely missed the obj_id = 42 part in the sub query
|
|
| Jan 23, 2016 at 16:20 | history | answered | dnoeth | CC BY-SA 3.0 |