Index on Number & Varchar2

From: Tillu <tosahil_at_yahoo.com>
Date: 2 Dec 2003 00:28:20 -0800
Message-ID: <ef9028f5.0312020028.24e6e52c_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 space

difference between number(10) and varchar2(10)

Tillu Received on Tue Dec 02 2003 - 09:28:20 CET

This message: [ Message body ]
Next message: Jeff Lambert: "How to emulate WRITETEXT / Writing to LONG fields"
Previous message: Leigh: "Oracle upgrade advice"
Next in thread: Mark D Powell: "Re: Index on Number & Varchar2"
Reply: Mark D Powell: "Re: Index on Number & Varchar2"

Contemporary messages sorted: [ by date ] [ by thread ] [ by subject ] [ by author ]

Original text of this message