Close
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
Read Down
Sign in
Close
Welcome!Log into your account
Forgot your password?
Read Down
Password recovery
Recover your password
Close
Search
Menu
Search
  • Latest News
  • Cybersecurity
  • Big Data and Analytics
  • Cloud
  • Mobile
  • Networking
  • Storage
  • Applications
  • IT Management
  • Small Business
  • Development
  • Database
  • Servers
  • Android
  • Apple
  • Innovation
  • Blogs
  • PC Hardware
  • Reviews
  • Search Engines
  • Virtualization
More
    Home Database
    • Database

    Revealing the Secrets to Coding SQL

    By
    Peter MacIntyre
    -
    November 6, 2002
    Share
    Facebook
    Twitter
    Linkedin

      “SQL Performance Tuning” is a book that will take the database developer to the next level. This book will help the experienced SQL programmer make his or her code sing in terms of efficiency of code and optimization of data retrieval.

      Peter Gulutzan and Trudy Pelzer do a wonderful job explaining the methods behind the madness of the most common SQL commands. They take the top eight SQL database products and compare each of them in terms of how they use standard commands. At the same time, the authors show you how to optimize your code and demonstrate the performance gains that you will see when the updated code is executed.

      The top eight SQL database products covered in this publication are: IBMs DB2, IBMs Informix, Computer Associates Ingres, Borlands Interbase, Microsoft SQL Server, the open source MySQL, Oracle and Sybase. For each standard command on each platform, the authors not only show you how to tune your code to make it run more efficiently, they also explain in great detail why the new code works better. This is a wonderful addition as it helps the programmer to get behind the tools and better understand what is going on within them. With that understanding, the programmer will have the skills needed to fine-tune code for maximum efficiency in the future.

      This book covers all the major commands within the SQL standard and also warns you of any anomalies within the specific tools to watch out for. The SELECT command, for example, is covered in great detail. And all the optional portions of the command like GROUP BY and ORDER BY are covered to show just how the SQL products are retrieving the information.

      All the aspects of using a SQL tool are also covered very well. “SQL Performance Tuning”, for example, provides definitions of tables and helps the reader understand the decisions that need to be made on the datatypes in the tables columns. In addition, the book shows how to best use indexes and how stored procedures are used. If a specific tool does not have a certain feature, you are informed of that as well. For example, the MySQL tool does not currently support stored procedures.

      The authors also add a performance gain gage at the end of each discussion showing the reader just how much better the new code using recommended optimizations executes on each of the eight database platforms.

      This book from Addison-Wesley will be very useful to any programmer who has a good understanding of how to use the SQL language and wants to produce code that runs as smoothly as possible. At its reasonable price, “SQL Performance Tuning” should be a useful addition to your library.

      • Title: SQL Performance Tuning
      • Authors: Peter Gulutzan
      • Publisher: Addison Wesley (www.aw.com)
      • Length: 495 pages
      • Length: 44.95 pages

      Peter MacIntyre is involved in custom software development, design and architecture. He lives in Prince Edward Island, Canada. Other reviews by Peter can be found at http://wwrg.cjb.net.

      Avatar
      Peter MacIntyre

      MOST POPULAR ARTICLES

      Android

      Samsung Galaxy XCover Pro: Durability for Tough...

      Chris Preimesberger - December 5, 2020 0
      Have you ever dropped your phone, winced and felt the pain as it hit the sidewalk? Either the screen splintered like a windshield being...
      Read more
      Cloud

      Why Data Security Will Face Even Harsher...

      Chris Preimesberger - December 1, 2020 0
      Who would know more about details of the hacking process than an actual former career hacker? And who wants to understand all they can...
      Read more
      Cybersecurity

      How Veritas Is Shining a Light Into...

      eWEEK EDITORS - September 25, 2020 0
      Protecting data has always been one of the most important tasks in all of IT, yet as more companies become data companies at the...
      Read more
      Big Data and Analytics

      How NVIDIA A100 Station Brings Data Center...

      Zeus Kerravala - November 18, 2020 0
      There’s little debate that graphics processor unit manufacturer NVIDIA is the de facto standard when it comes to providing silicon to power machine learning...
      Read more
      Apple

      Why iPhone 12 Pro Makes Sense for...

      Wayne Rash - November 26, 2020 0
      If you’ve been watching the Apple commercials for the past three weeks, you already know what the company thinks will happen if you buy...
      Read more
      eWeek


      Contact Us | About | Sitemap

      Facebook
      Linkedin
      RSS
      Twitter
      Youtube

      Property of TechnologyAdvice.
      Terms of Service | Privacy Notice | Advertise | California - Do Not Sell My Information

      © 2021 TechnologyAdvice. All Rights Reserved

      Advertiser Disclosure: Some of the products that appear on this site are from companies from which TechnologyAdvice receives compensation. This compensation may impact how and where products appear on this site including, for example, the order in which they appear. TechnologyAdvice does not include all companies or all types of products available in the marketplace.

      ×