char(1) vs Number(1)
From: CrazyKarma <skalki_at_gmail.com>
Date: Mon, 30 Nov 2009 09:59:08 -0800 (PST)
Message-ID: <e5e52f6f-63be-4975-ac75-27b685012602_at_z10g2000prh.googlegroups.com>
Quick check on whether char(1) is more efficient than number (1). Basically storing a bit value of either 0 or 1. since this is a numeric maybe its better to store this as number(1).
Date: Mon, 30 Nov 2009 09:59:08 -0800 (PST)
Message-ID: <e5e52f6f-63be-4975-ac75-27b685012602_at_z10g2000prh.googlegroups.com>
Quick check on whether char(1) is more efficient than number (1). Basically storing a bit value of either 0 or 1. since this is a numeric maybe its better to store this as number(1).
Did a simple test for 1million rows, the IO cost is the same but the number of bytes is double with number(1). This makes me think that char(1) is more efficient in storage.
any thoughts? Received on Mon Nov 30 2009 - 11:59:08 CST