G
George Potemkin
Guest
> that is because there is a 2 byte length prefix which is included by one and not the other. Probably dbanalys should add 4 bytes to the value of RECORD-LENGTH() - 2 byte length prefix and 2 byte record offset in block header. Then the value would accurately represents the space used by a record in data block. I thought about this choice when I wrote AreaDefrag program that is a kind of 4GL analogue of tabanalys: should it report the real space usage or should it match tabanalys (de-facto standart) or should it use the RECORD-LENGTH() value (native choice for 4GL). Not a big issue though. Best regards, George
Continue reading...
Continue reading...