On Fri, Sep 13, 2024 at 11:59 PM yudhi s <learnerdatabas...@gmail.com> wrote:
> >> >> Do you have any indexes? >> If not - you should, if yes - what are they? >> >> >> > Yes we have a primary key on this table which is on a UUID type column and > also we have other indexes in other timestamp columns . But how is this > going to help as we are going to update almost all the rows in the table? > But do you have an index on tab_part1.column1? And how slow is subquery?