Re: Implementation of boolean types.

From: Eagle Fan <eagle.f_at_gmail.com>
Date: 15 Jul 2005 02:57:28 -0700
Message-ID: <1121421448.738223.140180@f14g2000cwb.googlegroups.com>

Nod. Seems char(1) takes less space than number; SQL> select dump(x) from tt1;

DUMP(X)

---

Typ=2 Len=2: 193,2

SQL> desc tt1

 Name                                      Null?    Type
 ----------------------------------------- --------


----------------------------

 X                                                  NUMBER

SQL> select dump(x) from tt2
  2 ;

DUMP(X)

---

Typ=96 Len=1: 49

SQL> desc tt2

 Name                                      Null?    Type
 ----------------------------------------- --------


----------------------------

 X                                                  CHAR(1)

But how about the speed when do equal search, order by or other operations? Received on Fri Jul 15 2005 - 04:57:28 CDT