Results 1 to 2 of 2
  1. #1
    Join Date
    Mar 2004
    Location
    sweden
    Posts
    4

    simple varchar Q

    does the length of a varchar change performance a lot?
    I'm not sure if I should have 2 diifferent tables,
    one for
    pkey | num.value | varchar(50)
    and one for
    pkey | num.value | varchar(2200)

    or if I should only use the last one.

    Do I gain any performance if I split them up into two tables?

  2. #2
    Join Date
    Sep 2002
    Location
    UK
    Posts
    5,171
    The answer may depend on your DBMS. For Oracle, it would make no difference, as a VARCHAR only uses as much storage as it requires for the value it contains.

Posting Permissions

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