By using this site, you agree to our updated Privacy Policy and our Terms of Use. Manage your Cookies Settings.
443,369 Members | 1,147 Online
Bytes IT Community
+ Ask a Question
Need help? Post your question and get tips & solutions from a community of 443,369 IT Pros & Developers. It's quick & easy.

Index on Number & Varchar2

P: n/a
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
Jul 19 '05 #1
Share this question for a faster answer!
Share on Google+

This discussion thread is closed

Replies have been disabled for this discussion.