Length of a Table Name

  • When naming a table/sp/function, does the length effect performance?

    Nothing in our environments are allowed to exceed 35 char… therefore I assume the performance hit would be minuscule to the point it shouldn’t matter. However, if accessed x-amount per day, it can add up.

    “googling” it never seems to find an yes/no/somewhat/slightly/your-being-anal answer. It would be nice to finally have an answer though.

  • length of object names does not matter as far as perf is concerned.

    ---------------------------------------
    elsasoft.org

  • I wouldn't think naming matters at all. Once it's compiled, it's resolved to internal compiled objects.

Viewing 3 posts - 1 through 2 (of 2 total)

You must be logged in to reply to this topic. Login to reply