Oracle Performance Tuning Tips at atoz help blog-Avoid Using SELECT * Clauses

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 ! :)

Tweet