Oracle FAQ Your Portal to the Oracle Knowledge Grid
HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US
 

Home -> Community -> Usenet -> c.d.o.server -> CHAR vs VARCHAR(2) - Performance

CHAR vs VARCHAR(2) - Performance

From: <bert_man_at_my-deja.com>
Date: 2000/03/22
Message-ID: <8bbedn$r6v$1@nnrp1.deja.com>#1/1

From reading several of the threads here, it is my understanding that (beyond simple disk i/o) there is no real performance advantage of CHAR of VARCHAR(2). In fact, indexes built on VARCHAR(2) fields will likely perform (albeit marginally) better than those built on CHAR fields. It appears that the only risk in using VARCHAR(2) fields is a chance of chaining as dynamically sized VARCHAR data is passed in and out of the table.
Other than that, CHAR vs VCHAR kind of comes down to a matter of personal preference.
Does this seem to be accurate?

Sent via Deja.com http://www.deja.com/
Before you buy. Received on Wed Mar 22 2000 - 00:00:00 CST

Original text of this message

HOME | ASK QUESTION | ADD INFO | SEARCH | E-MAIL US