performance difference between varchar2(20) and varchar2(2000) - Page 2
DBAsupport.com Forums - Powered by vBulletin
Page 2 of 2 FirstFirst 12
Results 11 to 16 of 16

Thread: performance difference between varchar2(20) and varchar2(2000)

  1. #11
    Join Date
    Apr 2003
    Location
    South Carolina
    Posts
    148
    Not that it is tooooo important but you also will incur an additional byte of overhead in the block header for each row with any column over 250 bytes.

    Gregg

  2. #12
    Join Date
    May 2002
    Location
    USA
    Posts
    462
    interesting , is it on the row data or table structure ( all columns width ).

    where can i find more info on below statement

    Not that it is tooooo important but you also will incur an additional byte of overhead in the block header for each row with any column over 250 bytes.

  3. #13
    Join Date
    Jan 2001
    Posts
    3,131
    I herby nominate this thread as one of the most pointell Oracle discussions in the history of dbasupport.com

    All in favor.

    MH
    I remember when this place was cool.

  4. #14
    Join Date
    Aug 2002
    Location
    Atlanta
    Posts
    1,187
    Originally posted by Mr.Hanky
    I herby nominate this thread as one of the most pointell Oracle discussions in the history of dbasupport.com

    All in favor.

    MH
    Aye,agreed

    wtf is pointell?
    I'm stmontgo and I approve of this message

  5. #15
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,095
    Originally posted by stmontgo
    Aye,agreed

    wtf is pointell?
    You agreed, but you have no clue what pointell means? WTF???
    Jeff Hunter
    marist89@yahoo.com
    http://marist89.blogspot.com/
    Get Firefox!
    "I pledge to stop eating sharks fin soup and will not do so under any circumstances."

  6. #16
    Join Date
    Jan 2001
    Posts
    3,131
    LISTEN TO WHAT I MEAN , NOT WHAT I SAY.

    DAMN YOU LINEAR THINKING TECHNICAL TYPES!



    MH
    I remember when this place was cool.

Posting Permissions

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



Click Here to Expand Forum to Full Width