Asterisk In Select Query
Posted on 2006-05-18
I have a query that does something like the following:
SELECT d.*, a.* FROM TABLE1 d, TABLE2 a WHERE ......
Is there a degradation in performance or are the indexes ignored by using the d.* and a.* instead of the actual column names like d.COLUMN1, d.COLUMN2, a.COLUMN1, a.COLUMN2? Thanks.
BTW, I am using SQL Server 2000, 2005 and Oracle 9 and 10.