Index on Number & Varchar2
From: Tillu <tosahil_at_yahoo.com>
Date: 2 Dec 2003 00:43:42 -0800
Message-ID: <ef9028f5.0312020043.3f13d4a6_at_posting.google.com>
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).
Date: 2 Dec 2003 00:43:42 -0800
Message-ID: <ef9028f5.0312020043.3f13d4a6_at_posting.google.com>
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 spacedifference between number(10) and varchar2(10)
Sahil Received on Tue Dec 02 2003 - 09:43:42 CET