Results 1 to 3 of 3

Thread: % performance impact if use varchar instead of char?

  1. 02-19-2004, 06:22 PM #1
    ravi
    ravi is offline Registered User
    Join Date
    Nov 2002
    Posts
    231

    % performance impact if use varchar instead of char?

    Hi,
    Anybody have any idea howmuch % of performance will be affect if we are using varchar instead of char data type?.
    Thanks,
    Ravi
    Reply With Quote Reply With Quote
  2. 02-19-2004, 07:50 PM #2
    skhanal
    skhanal is offline Experts
    Join Date
    Nov 2002
    Location
    New Jersey, USA
    Posts
    3,932
    It's a classic design choice flame. With SQL 2000, the engine handles varchar field that allow null differently from that does not allow it. So it's really hard to get a number.

    As a convention I use varchar when length is not fixed.
    Last edited by skhanal; 02-19-2004 at 07:52 PM.
    Reply With Quote Reply With Quote
  3. 02-20-2004, 08:51 AM #3
    rmiao
    rmiao is offline Registered User
    Join Date
    Sep 2002
    Posts
    5,938
    Depends on column length, don't make sense to use varchar(10) for instance.
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules