On Jan 17, 2007, at 7:34 PM, Roger Clary wrote:
Also, for anything other than quick interactive playing with SQL, never do "Select *". Instead, do: Select ( column1, column2, ... ) ... as "Select *" results will change if you ever modify the table structure.Thanks, Craig. I didn't know this.
Also in many sql engines defining the columns has a significant impact on performance
Sam D _______________________________________________ Unsubscribe or switch delivery mode: <http://www.realsoftware.com/support/listmanager/> Search the archives of this list here: <http://support.realsoftware.com/listarchives/lists.html>
