Re: any improved efficiency over breaking long fields

From: Gregory J. Pucka <puckag_at_sprintmail.com>
Date: 1997/01/31
Message-ID: <32F2B569.6645@sprintmail.com>#1/1

amit srivastava wrote:
>
> Is there any advantage over putting fields of type long in a
> separate table by themselves assoc. with the primary key of the table?
>
> for ex.
> table t table t_note
> ------ -----------
> id number(8) <-primary key-> id number(8)
> a varchar(20) note long

A big improvement!! This way Oracle is not required to do all of the I/O to read through the long field. Long data in a regular table leads to lots of chaining and migrating of the rows.

Greg Pucka
Management Consultant, TUSC
puckag_at_tusc.com Received on Fri Jan 31 1997 - 00:00:00 CST