Methods of Tuning a Database Essay

Open, View, and/or
Download this Document

Total Length: 790 words ( 3 double-spaced pages)

Total Sources: 3

Page 1 of 3

Tuning a database is a series of activities that are carried out to optimize and standardize the performance of a database. The main goal of database tuning is to maximize the efficiency and performance of a database through promoting the effective use of system resources. While most systems are developed in a manner that they manage their use of system resources, there is room for enhancing their efficiency and performance. The process of database tuning involves customizing the settings and configuration of a database and its system resources. Database tuning is carried out because of various reasons including data changes, changes in codes such as releases and upgrades, and changes in usage patterns. In addition, database tuning is sometimes carried out because query optimization is imprecise and the inefficiency of underlying technologies. There are several methodologies that are utilize for tuning a database including SQL tuning, query tuning, physical tuning, and infrastructure tuning.

SQL tuning is a process that focuses on ensuring that SQL statements issued by an application will run within the shortest possible duration of time. SQL tuning usually entails three basic steps that are carried out repeatedly until the desired system performance is reached or there are no more SQL statements to be tuned (Oracle, n.d.).

Stuck Writing Your "Methods of Tuning a Database" Essay?

View All Our Example Methods of Tuning a Database Essay

Have A Custom Example Essay Written

First, SQL tuning begins with identification of high load or top SQL statements that handle the application workload and systems resources through examining the history of the system's SQL execution. The second step involves authenticating that execution plans from the query optimizer for the SQL statements perform logically. The third step is implementing corrective actions in order to produce better execution plans for SQL statements that are performing poorly. Sinha (2016) provides some examples of SQL including the following . . .

SELECT e.first_name, e.last_name, c.country FROM employee e, countries c WHERE e.country_id = c.id AND e.last_name = 'HALL';

SELECT p.product_id

FROM products p

WHERE p.item_no IN (SELECT i.item_no

FROM items i);

SELECT * FROM student c WHERE NOT EXISTS (SELECT 1 FROM class a WHERE a.student_num = c.student_num)

The second methodology for tuning a database is query tuning, which is mostly carried out because queries usually require complex optimization that is mostly conducted inconsistently. The process involves breaking the queries into smaller units through the use of temp tables to mix results (Linwood, n.d.). Some of the best practices when conducting query tuning include using hints and indexes to enhance….....

Show More ⇣

     Open the full completed essay and source list


OR

     Order a one-of-a-kind custom essay on this topic


sample essay writing service

Cite This Resource:

Latest APA Format (6th edition)

Copy Reference
"Methods Of Tuning A Database" (2017, June 05) Retrieved June 5, 2026, from
https://www.aceyourpaper.com/essays/methods-tuning-database-2165678

Latest MLA Format (8th edition)

Copy Reference
"Methods Of Tuning A Database" 05 June 2017. Web.5 June. 2026. <
https://www.aceyourpaper.com/essays/methods-tuning-database-2165678>

Latest Chicago Format (16th edition)

Copy Reference
"Methods Of Tuning A Database", 05 June 2017, Accessed.5 June. 2026,
https://www.aceyourpaper.com/essays/methods-tuning-database-2165678
   

Open, View, and/or
Download this Document
order custom essay example