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)
Tillu