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
--
Please see the official ORACLE-L FAQ: http://www.orafaq.net
--
Author: sahil patel
INET: tosahil_at_rediffmail.com
Fat City Network Services -- 858-538-5051 http://www.fatcity.com
San Diego, California -- Mailing list and web hosting services
---------------------------------------------------------------------
To REMOVE yourself from this mailing list, send an E-Mail message
to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in
the message BODY, include a line containing: UNSUB ORACLE-L
(or the name of mailing list you want to be removed from). You may
also send the HELP command for other information (like subscribing).
Received on Tue Dec 02 2003 - 02:59:25 CST
