Re: Table with ~255+ columns

From: Sayan Malakshinov <xt.and.r_at_gmail.com>
Date: Thu, 19 Nov 2020 03:39:52 +0300
Message-ID: <CAOVevU78F+nO0P-od0Q4cF+Q2DQDTFS4vQS92ouGry5Nou3MdA_at_mail.gmail.com>

Hi Lok,

As I see you are on 11.2.0.4 now. So first of all, I would suggest you to upgrade to at least oracle 12.2, since intra-block row chaining doesn't work for updates before 12.2:

http://orasql.org/2017/02/12/intra-block-row-chaining/
http://orasql.org/2017/06/17/intra-block-row-chaining-optimization-in-12-2/
http://orasql.org/wp-content/uploads/2017/04/Intra-block-row-chainingRuOUG.pdf

The last example in the presentation above shows how just 1 row has been split into 101 blocks.
So any updates of null values in the end of rows you ran before split row into another block.

--

Best regards,
Sayan Malakshinov
Oracle ACE Associate
Oracle DB Developer Choice Award winner
http://orasql.org

--

http://www.freelists.org/webpage/oracle-l Received on Thu Nov 19 2020 - 01:39:52 CET