Avoid Using SELECT * Clauses
•The dynamic SQL column reference (*) gives you a way to refer to all of the columns of a table.
•Do not use the * feature because it is very inefficient -- the * has to be converted to each column in turn.
• The SQL parser handles all the field references by obtaining the names of valid columns from the data dictionary and substitutes them on the command line, which is time consuming.
Note : Provide your comments by clicking below options! Thanks ! :)
0 comments:
கருத்துரையிடுக