Please start any new threads on our new
site at https://forums.sqlteam.com. We've got lots of great SQL Server
experts to answer whatever question you can come up with.
| Author |
Topic |
|
dinsshetty
Starting Member
1 Post |
 Posted - 2006-12-05 : 18:06:02
|
| Hi ,I have query related to using of Alias names for the Tables in SQL query, will the performance of the query affected if we use Alias name for tables in joins. considering the fact that there was no need to use alias name in those joins.Your response is highly appreciated.Regrads |
|
|
jezemine
Master Smack Fu Yak Hacker
2886 Posts |
Posted - 2006-12-05 : 18:58:45
|
I have never heard of using aliases affecting perf.
SqlSpec: a fast and comprehensive data dictionary generator for
SQL Server 2000/2005, Analysis Server 2005, Access 97/2000/XP/2003
http://www.elsasoft.org |
 |
|
|
harsh_athalye
Master Smack Fu Yak Hacker
5581 Posts |
Posted - 2006-12-05 : 23:26:31
|
| Aliases are used only to avoid writing lengthy table names again and again...it has nothing to do with the performance.Harsh AthalyeIndia."Nothing is Impossible" |
|
|
|
pootle_flump
1064 Posts |
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-06 : 10:07:26
|
quote:
Originally posted by pootle_flump
Coo. Some questions are like buses.http://www.dbforums.com/showthread.php?t=1612356HTH
The site seems downThere seems to have been a problem with the database.Please try again by clicking the Refresh button in your web browser.An E-Mail has been dispatched to our Technical Staff, whom you can also contact if the problem persists.We apologise for any inconvenience.MadhivananFailing to plan is Planning to fail |
|
|
|
pootle_flump
1064 Posts |
Posted - 2006-12-06 : 10:33:36
|
Really? Working ok now. I will see if I can find anything out.Thanks for the HU  |
|
|
|
madhivanan
Premature Yak Congratulator
22864 Posts |
Posted - 2006-12-06 : 23:37:39
|
| Yes. Now it is workingMadhivananFailing to plan is Planning to fail |
|
|
|
|
|
|
Alias name for table