CODEWITHSUNDEEP
mysqlsql-serveroracle-database
user1
user1

Reputation: 4131

Does column name width affect sql query performance in Microsoft SQL Server/Oracle/MySQL?

Does width of a column name really matter when I do select or insert or when I run stored procedure? Any performance implications with respect to column name width.

I guess the answer is No. But I still want to get more insights to it. May be different databases internally refer sql table column names differently. The answer which is true for MS Sql Server may not hold true for Oracle?

Upvotes: 2

Views: 780

Answers (1)

Ben Thul
Ben Thul

Reputation: 32697

For SQL Server, I'm going to say "no". The name is just a reference into the metadata for the table that says what the column position and data type are. I'd venture to say it's the same for mySQL as well, but that's purely speculative.

That said, there's a saying in software in general that goes something like "imagine that the person who has to maintain your code is a homicidal maniac". So feel free to push the limits of the size of the column name. But keep that saying in mind. :)

Upvotes: 1

Related Questions