1. Forum
  2. Usenet
  3. COMP.SYS.IBM.AS400.MISC

  • Long table names

    From Jonathan Ball@21:1/5 to Jonathan Ball on Thu Oct 24 16:26:48 2019
    On 10/24/2019 4:25 PM, Jonathan Ball wrote:
    Some time back, I seem to recall a possible performance issue with long DB2 table names above a certain length.  I can't recall what the performance problem was, and I also can't remember what the threshold name length was.
    I want to say it was around 35 characters, but I don't have a high degree
    of confidence in that.

    Does this ring a bell with anyone?

    Right after I hit Send, I had a sudden flash that the issue possibly arose
    due to long column names, rather than long table names.

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Jonathan Ball@21:1/5 to All on Thu Oct 24 16:25:39 2019
    Some time back, I seem to recall a possible performance issue with long DB2 table names above a certain length. I can't recall what the performance problem was, and I also can't remember what the threshold name length was.
    I want to say it was around 35 characters, but I don't have a high degree
    of confidence in that.

    Does this ring a bell with anyone?

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)
  • From Hauser@sss-software.de@21:1/5 to All on Mon Nov 4 23:09:37 2019
    When accessing your table are you using SQL or System Naming Conventions?
    Do you qualify your table or not?

    When using system naming conventions and unqualified access, the short system names are used, i.e. they must be first determined from the long column names.
    ... but it should not cause a performance issue.

    Birgitta

    --- SoupGate-Win32 v1.05
    * Origin: fsxNet Usenet Gateway (21:1/5)