writing the perfect code

Hi,

In your opinion, what would define the perfect code.How can we optimise our code,by using less loop statement / avoiding select * ??

Once we receive the Functional specifications,what should we keep in mind before we start wriitng the code.

Please advice.

Thanks