Hello i have the same problem but in update the inner selet goes its self but update dont:
I have some questions on DBC space ?
First of all i need to increatse space on DBC .(Here we can't add more disk sapce )only the option is we can reduce space from other db's or users ,then the space is should be increase on DBC ? Right ?
And we use some query i.e ,
SELECT tablename, SUM(currentperm), SUM(peakperm) FROM dbc.tablesize WHERE databasename = 'dbc' GROUP BY 1 QUALIFY RANK() OVER (ORDER BY SUM(currentperm) DESC) <= 20;
Result is :