Use QueryTuner in DataStudio3.1.1 for query optimization

The IBMDataStudio3.1.1 product package contains the SQL Performance Tuning tool, which is seamlessly integrated with database development and management tools. DataStudio3.1.1 you can call the SQL Performance Tuning tool to optimize queries when editing SQL statements, editing Routine, and compiling javaJDBC code.

The IBM Data Studio 3.1.1 product package contains SQL Performance tuning tools that are seamlessly integrated with database development and management tools. Data Studio 3.1.1 you can call the SQL Performance Tuning tool to optimize queries when editing SQL statements, editing Routine, and compiling java JDBC code.

This article will detail how to use the integrated SQL Performance Tuning tool in the above application scenarios of Data Studio 3.1.1.

The IBM Data Studio 3.1.1 product package contains SQL Performance tuning tools that are seamlessly integrated with development and management tools. Data Studio 3.1.1 you can call the SQL Performance Tuning tool to optimize queries when editing SQL statements, editing Routine, and compiling java JDBC code. This article will detail how to use the integrated SQL Performance Tuning tool in the above application scenarios of Data Studio 3.1.1. This article introduces the advanced features of Data Studio 3.1.1. Therefore, you need to understand the basic functions of Data Studio 3.1.1 before reading this article.

Data Studio Overview

Data Studio is a free integrated database development and management tool platform developed by IBM. It is part of the IBM Data lifecycle management tools and solutions family. You can use it to design and develop database applications, optimize database application data operations, and monitor database health. It can be installed in Red Hat®Linux, SUSE Linux, Windows, and AIX (only available for Data Studio Web Console components) operating systems.

Data Studio provides services for three application scenarios:

• Database Management scenario. Data Studio 3.1.1 provides powerful database object management functions, which can replace DB2 Control Center as a tool for managing database objects.
• Database Application development scenario. Data Studio 3.1.1 provides powerful database application development tools and supports Java™SQL pl and PL/SQL routines, XML editor, and other development methods. It can also be integrated with IBM's query optimization tools to Optimize Query performance.
• Monitoring and Management of database health and availability plan jobs. Data Studio 3.1.1 provides a Web-based monitoring tool for health and availability. It can monitor the health status of databases and generate alarms. It also provides a tool for managing scheduled jobs.

Data Studio 3.1.1 integrates the functions of Optim Development Studio, Optim Database Administrator, and earlier IBM Data Studio into a single product, and integrates some of the functions of Optim Query Workload Tuner. In this way, Data Studio provides higher availability for database management and application development.

Figure 1.IBM Data Studio 3.1.1

Query Tuner Introduction

The integrated Ouery Tuner component in Data Studio 3.1.1 is part of the Infosphere Optim Query Workload Tuner function. Infosphere Optim Query Workload Tuner is a product charged with a separate license, but some of the integrated Data Studio can be used for free.

In the development and application of databases, some complicated data query and access links often have design defects, which seriously affects the application efficiency, at this time, even experienced DBAs cannot start. Not only can database administrators (DBAs) manage database objects and maintain database applications, but developers (developers) can optimize database queries and designs to integrate best practices and advisor functions.

Data Studio 3.1.1 integrated with Query Tuner has the following performance advantages:

• Seamless integration with Data Studio in a widely used Eclipse Development Environment
• By enabling developers to optimize SQL in the development stage, the overhead and risks are reduced.
• Encourage developers to collaborate with database administrators (DBAs. DBAs can better understand which SQL statements are used to access the database and facilitate the execution of optimization policies. developers can also learn more about database optimization.

Install the Integrated Query Tuner component in IBM Data Studio 3.1.1

The IBM Data Studio 3.1.1 product package contains the SQL Performance Tuning tool. You only need to Select the features to install during the installation of IBM Data Studio 3.1.1 (Select the features to be installed) in this step, SELECT Query Tuning.

Figure 2. Check Query Tuning during installation)

After the installation is complete, you can use the query optimization function in Data Studio 3.1.1.