That's not what REPLACE does, please read the documentation on what it actually does. It replaces the whole file, it doesn't pertain to specific records. UPDATE will apply to specific records.
... View more
thanks to everyone. we did it finally. we created a temporary table on db side (includes joins etc) and executed query with it. Then we took the view from it with a simple query without joins. It worked in seconds.
... View more
