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

Home -> Community -> Usenet -> c.d.o.server -> any improved efficiency over breaking long fields

any improved efficiency over breaking long fields

From: amit srivastava <amit_at_intrex.net>
Date: 1997/01/30
Message-ID: <32F0DFC8.4B34@intrex.net>#1/1

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
Received on Thu Jan 30 1997 - 00:00:00 CST

Original text of this message

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