asterisk (select * ) - possible disadvantages?
533392Sep 12 2006 — edited Apr 27 2007hi!
Could you list all possible disadvantages you can see of using asterisk in views/inline views etc.?
For instance, I can't realize this wide-used practice to select all columns by using asterisk in inline view and then let's say select only two columns from 50 columns of this view at upper level of query. something like this
select cv.id,
cv.name
from
(
select cv.* from some_table) cv;
I guess there might be some other reasonable exaplanations/reasons not use asterisk.
Thank you