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 would think that syntax should be working in SQLA too (at least I noticed nothing incompatible), identical schma assumed. Did you give it a try?
Yes, I gave it a try, but I think that there is no 'over (partion by xx)' or similar contruct in Adaptive Server 12. Ok, by now I realised that Adaptive Server and SQL Anywhere are different products. I am sorry I asked on the wrong site.
Could someone delete the entire question. I thought this was a site for ASE and didnt know the difference to Sybase Anywhere. Sorry for that. I will repost on StackOverflow.