Home -> Usenet -> comp.databases.oracle -> Large Key and Lots of Column

Large Key and Lots of Column

From: Dong Duong Nguyen <dnguyeb_at_osf1.gmu.edu>
Date: 1995/05/27
Message-ID: <3q8b5e$30o_at_portal.gmu.edu>#1/1 







Hi,


        I appologize if this is a stupid question.



        I have a 1 table application that contains a 1 field key.
This key is 55 varchar2 big.  This also has 25 fields. Half of them are
only 1 character fields however.  Three fields are 2000 varchars in size.



        We decided to do this to keep things simple.  However, will the large
key and large number of columns cause any performance problems.  Should I try
and use some kind of numeric surrogate for the key.  Should I also try to 
break the table up.



Thanks doug
Received on Sat May 27 1995 - 00:00:00 CEST












Original text of this message