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