I have to update a column in a very, very large table. So performance is a big issue.
The question is the same as this one, but only for Sybase. Is there a way to do it without a self join like in the top voted answer for Oracle?
This was my first attempt, but it is by orders to slow for the table it is intended for:
I'm frankly a bit confused, because the StackExchange post doesn't address updates at all.
However - as far as I can tell, virtually any of the SQL queries given in the answers of that StackExchange post will work in SQL Anywhere. SQL Anywhere supports (of course) subqueries and joins to derived tables. SQL Anywhere 9.0.1 and up supports
answered 13 Jul '10, 19:45