Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> comp.databases.theory -> Re: How are unlimited fields stored?

Re: How are unlimited fields stored?

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


"stu" <smcgouga_at_nospam.co.uk> wrote in
news:ap5mue$s7m$1$8300dec7_at_news.demon.co.uk:

> 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
http://www.hpdbe.com
Received on Wed Oct 23 2002 - 16:33:28 CDT

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US