Re: How are unlimited fields stored?

From: Pablo Sanchez <pablo_at_dev.null>
Date: 23 Oct 2002 16:33:28 -0500
Message-ID: <Xns92B09F343C713pingottpingottbah_at_209.189.89.243>

"stu" <> wrote in news:ap5mue$s7m$1$

> How are large unlimited fields stored? I think im right when i say
> if you have a TEXT(30) and only use 3 chars the dbms will physically
> layout 30 char space before the start of the next record. This is
> fine but how does the dbms handle memo fields that can be huge?

I don't know what a memo field is but assuming that it's similar to CLOB/BLOB's, the RDBMS typically chain together their atomic storage unit, to accommodate monster fields.

Pablo Sanchez, High-Performance Database Engineering
Received on Wed Oct 23 2002 - 23:33:28 CEST

Original text of this message