| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
 |
 | |||
| Oracle FAQ | Your Portal to the Oracle Knowledge Grid | |
|
| |||
Home -> Community -> Mailing Lists -> Oracle-L -> OT - Performance impacts with column and table aliases in SQL Ser
Hello all,
I know, I know - An Oracle list!!!!. However some of us work with many databases (our shop has Oracle, SQL Server, Adabas, and Sybase), so maybe someone on this list can help. The subject line should give enough info to delete the message if you hate the 'other' databases.
I was asked recently if alasing all columns and tables in SQL statements in stored procedures has any performance impacts. I've never noticed any problems using aliases, nor have I seen any reference to performance hits due to using aliases. The app is an MS component design thing in which all the database calls are made from the data tier (VB) to stored procedures in SQL Sever.
Any thought on this?
Mike Lanteigne
The views expressed here are mine and do not reflect the official position of my employer or the organization through which the internet was accessed.
--
Please see the official ORACLE-L FAQ: http://www.orafaq.com
--
Author: Lanteigne, Mike
INET: MLanteigne_at_edc-see.ca
Fat City Network Services -- (858) 538-5051 FAX: (858) 538-5051 San Diego, California -- Public Internet access / Mailing Lists --------------------------------------------------------------------To REMOVE yourself from this mailing list, send an E-Mail message to: ListGuru_at_fatcity.com (note EXACT spelling of 'ListGuru') and in the message BODY, include a line containing: UNSUB ORACLE-L (or the name of mailing list you want to be removed from). You may also send the HELP command for other information (like subscribing). Received on Tue Apr 17 2001 - 11:42:53 CDT
 |
 |