Index on Number & Varchar2

From: Tillu <>
Date: 2 Dec 2003 00:43:42 -0800
Message-ID: <>

One of the column in a new table can be ename - varchar2(20) or hase_code_ename - number(11) – Hash Code generated by JAVA. We are going to create non-unique index on this column as one frequent query will have where clause on this column only. Choice is either varchar2(20) or number(11).
1.	Is Non-unique index on Number is faster then varchar2? Why?
2.	If Number column has negative values, then will it affect
performance of Non-unique index on it?
3.	How much space Number & Varchar2 consume? i.e storage space
difference between number(10) and varchar2(10)

Sahil Received on Tue Dec 02 2003 - 09:43:42 CET

Original text of this message