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 -> Re: Should key be number, varchar2[8] or varchar2[32]???

Re: Should key be number, varchar2[8] or varchar2[32]???

From: Philip Hoggins - Sun UK - Application Systems Engineer <ph87491_at_broken.uk.sun.com>
Date: 25 Mar 1999 14:23:01 GMT
Message-ID: <7ddgs5$2dc@flonk.uk.sun.com>


Without a doubt a key field will benefit if if is of type number. The benefits may only manifest themselves on tables with large volumes of data though.

--



Phil Hoggins
Sun Microsystems Ltd
Citygate, Cross Street
Sale, Cheshire M33 7JR E-mail: Philip.Hoggins_at_uk.sun.com
Received on Thu Mar 25 1999 - 08:23:01 CST

Original text of this message

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