This week's book giveaway is in the OCMJEA forum.
We're giving away four copies of OCM Java EE 6 Enterprise Architect Exam Guide and have Paul Allen & Joseph Bambara on-line!
See this thread for details.
The moose likes JDBC and the fly likes Does HF SQL cover creating efficient queries? Big Moose Saloon
  Search | Java FAQ | Recent Topics | Flagged Topics | Hot Topics | Zero Replies
Register / Login


Win a copy of OCM Java EE 6 Enterprise Architect Exam Guide this week in the OCMJEA forum!
JavaRanch » Java Forums » Databases » JDBC
Bookmark "Does HF SQL cover creating efficient queries?" Watch "Does HF SQL cover creating efficient queries?" New topic
Author

Does HF SQL cover creating efficient queries?

Alden Leatherman
Greenhorn

Joined: Mar 09, 2006
Posts: 7
I know some SQL can be obtuse and inefficient causing poor performance. Does this book have tips on avoiding these problems and writing clean, efficient queries?
Lynn Beighley
author
Ranch Hand

Joined: Sep 12, 2007
Posts: 82
I definitely focus on normalization as a way to increase efficiency. I also discuss, although not in great detail, writing more efficient queries.


Lynn Beighley<br />Author, Head First SQL
 
It is sorta covered in the JavaRanch Style Guide.
 
subject: Does HF SQL cover creating efficient queries?