CODEWITHSUNDEEP
sql-servertable-alias
user1482852
user1482852

Reputation: 94

Is there any performance slowdown while using custom table alias instead of direct table name with columns in sql select command?

I am working on project with huge data and usage. Many procedures are being used with multiple joined SQL Select queries.

My friend told me that using column names with table name is much better in respect to performance instead using column with table alias.

Query my friend suggested

select Employee.Name, Employee.Address, District.DistName
From Employee
INNER JOIN District ON Employee.DistCode=District.DistCode

Query I am currently using

select e.Name, e.Address, dist.DistName
From Employee e
INNER JOIN District dist ON e.DistCode=dist.DistCode

As far as I know, table aliases boost up query readability. Is there also any performance effect with table aliasing vs direct table name.

Upvotes: 0

Views: 117

Answers (0)

Related Questions