Re: Bad Practices

From: "Philip Olson" <philip@cornado.com> > They're very useful. Also, regarding SQL, don't do "SELECT * ..." all the > time as it's overkill if not all fields are being used. And, in fact, doing a "SELECT *" ends up precluding most optimizations within a query engine! Selecting only what you really need can give speedups in queries in the order of 3 orders of magnitude (where the query results can be satisfied via indices). Mark Charette@sneezy.org Former (and still occasionally) Oracle performance guy. ----------- "When the unknown is thought to be unknowable, gaps in knowledge are too readily filled by fancy, so long as the fancy is consistent with faith." -- Sherwin B. Newland, M.D., "The Mysteries Within".