SQL: Back to the Basics{3}


by Evin C
This week I have ventured into a peer-reviewed article by Craig S Mullins who speaks on how users can hinder performance of applications through the use of inefficient SQL commands. From the proper way to use SELECT or even the command WHERE, this article shows users how they can make simple query mistakes by misusing these SQL commands. One of the major inefficiencies found with users and their work in DBMS software is the unnecessary queries performed and the scope of the queries, whether it be adding to many columns or not refining your search enough. The article continues to speak on the simple ways one can get around these simple mistakes and make their SQL even better.

Considering our work in class is revolving around SQL and the use of it, I found this article to be quite interesting. Although it wasn’t as detailed as I had hoped for it definitely gave me some oversight to how to structure my commands for the future. With Project 2 on the way, I figure we all will be looking for ways to better improve our code and relations. Using this article or any of the others throughout our classes blog site can hopefully improve our chances at doing well.

Couldn’t hurt!

Reference:

Mullins, C. S. (2010, December). Sql performance basics. Retrieved from http://web.ebscohost.com/ehost/detail?sid=d7577d59-e873-4cbf-8880-13a53cd970a7@sessionmgr115&vid=3&hid=19&bdata=JnNpdGU9ZWhvc3QtbGl2ZQ==