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. 06-23-2004, 01:11 PM #11
    gbrabham
    gbrabham is offline Member
    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
    Reply With Quote Reply With Quote Share on Google+
  2. 06-23-2004, 01:16 PM #12
    prakashs43
    prakashs43 is offline Senior Member
    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.
    Reply With Quote Reply With Quote Share on Google+
  3. 06-23-2004, 01:44 PM #13
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    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.
    Reply With Quote Reply With Quote Share on Google+
  4. 06-23-2004, 01:55 PM #14
    stmontgo's Avatar
    stmontgo
    stmontgo is offline Senior Advisor
    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
    Reply With Quote Reply With Quote Share on Google+
  5. 06-23-2004, 02:06 PM #15
    marist89's Avatar
    marist89
    marist89 is offline Super-Genius
    Join Date
    Nov 2000
    Location
    greenwich.ct.us
    Posts
    9,092
    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."
    Reply With Quote Reply With Quote Share on Google+
  6. 06-23-2004, 02:21 PM #16
    Mr.Hanky's Avatar
    Mr.Hanky
    Mr.Hanky is offline X-Mas poo
    Join Date
    Jan 2001
    Posts
    3,134
    LISTEN TO WHAT I MEAN , NOT WHAT I SAY.

    DAMN YOU LINEAR THINKING TECHNICAL TYPES!



    MH
    I remember when this place was cool.
    Reply With Quote Reply With Quote Share on Google+
« 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

Click Here to Expand Forum to Full Width