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

On 25 Mar 1999 14:23:01 GMT, ph87491_at_broken.uk.sun.com (Philip Hoggins - Sun UK - Application Systems Engineer) wrote:

>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.
>

Presumably you believe this is becuase of a number being stored at two digits per byte?

I would expect a varchar or raw key to be better because it avoids datatype conversion between client and server. Received on Sat Mar 27 1999 - 09:35:53 CST