Generated by All in One SEO v5.0.1.1, this is an llms.txt file, used by LLMs to index the site.

# Tosska Technologies Limited

Alternative Wisdom

## Sitemaps

- [XML Sitemap](https://tosska.com/sitemap.xml): Contains all public & indexable URLs for this website.

## Posts

- [Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® - System Requirements](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-for-oracle-system-requirements/) - Before installing Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle®, please make sure your system meets the following minimum hardware and software requirements: CPU 1.8 GHz Processor Memory 2 GB of RAM minimum, 4 GB of RAM recommended Hard Disk Space 200 MB of disk space for 32-bit installation 400 MB of disk
- [Tosska SQL Tuning Expert Pro (TSE Pro™) 5.0.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-5-0-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 5.0.0 Release Notes
- [Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss® - System Requirements](https://tosska.com/tosska-sql-tuning-expert-pro-tseg-pro-for-opengauss-system-requirements/) - Before installing Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss®, please make sure your system meets the following minimum hardware and software requirements: CPU 1.8 GHz Processor Memory 2 GB of RAM minimum, 4 GB of RAM recommended Hard Disk Space 200 MB of disk space for installation Operating System Microsoft Windows® 7 Microsoft
- [Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss 1.8.1 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tseg-pro-for-opengauss-1-8-1-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss 1.8.1 Release Notes
- [Tosska DB Ace Enterprise (DBAM™) for MySQL® - System Requirements](https://tosska.com/tosska-db-ace-enterprise-dbam-for-mysql-system-requirements/) - Before installing Tosska DB Ace Enterprise (DBAM™) for MySQL®, please make sure your system meets the following minimum hardware and software requirements: CPU 1.8 GHz Processor Memory 2 GB of RAM minimum, 4 GB of RAM recommended Hard Disk Space 400 MB of disk space for 64-bit installation Operating System Microsoft Windows® 7 64-bit Microsoft
- [Tosska DB Ace Enterprise (DBAM™) for MySQL 3.0.0 Release Notes](https://tosska.com/tosska-db-ace-enterprise-dbam-for-mysql-3-0-0-release-notes/) - Click to view Tosska DB Ace Enterprise (DBAM™) for MySQL 3.0.0 Release Notes
- [Tosska DB Ace Enterprise (DBAO™) for Oracle® - System Requirements](https://tosska.com/tosska-db-ace-enterprise-dbao-for-oracle-system-requirements/) - Before installing Tosska DB Ace Enterprise (DBAO™) for Oracle®, please make sure your system meets the following minimum hardware and software requirements: CPU 1.8 GHz Processor Memory 2 GB of RAM minimum, 4 GB of RAM recommended Hard Disk Space 400 MB of disk space for 64-bit installation Operating System Microsoft Windows® 7 64-bit Microsoft
- [Tosska DB Ace Enterprise (DBAO™) for Oracle 4.0.0 Release Notes](https://tosska.com/tosska-db-ace-enterprise-dbao-for-oracle-4-0-0-release-notes/) - Click to view Tosska DB Ace Enterprise (DBAO™) for Oracle 4.0.0 Release Notes
- [Tosska DB Ace Enterprise (DBAP™) for PostgreSQL® - System Requirements](https://tosska.com/tosska-db-ace-enterprise-dbap-for-postgresql-system-requirements/) - Before installing DB Ace Enterprise for PostgreSQL®, make sure your system meets the following minimum hardware and software requirements: CPU 1.8 GHz Processor Memory 2 GB of RAM minimum, 4 GB of RAM recommended Hard Disk Space 200 MB of disk space for installation Operating System Microsoft Windows® 7 Microsoft Windows® 10 Microsoft Windows® 11
- [Tosska DB Ace Enterprise (DBAP™) for PostgreSQL 1.1.0 Release Notes](https://tosska.com/tosska-db-ace-enterprise-dbap-for-postgresql-1-1-0-release-notes/) - Click to view Tosska DB Ace Enterprise (DBAP™) for PostgreSQL 1.1.0 Release Notes
- [Tosska DB Ace Enterprise (DBAP™) for PostgreSQL 1.0.5 Release Notes](https://tosska.com/tosska-db-ace-enterprise-dbap-for-postgresql-1-0-5-release-notes/) - Click to view Tosska DB Ace Enterprise (DBAP™) for PostgreSQL 1.0.5 Release Notes
- [How Many Ways Can You Tune an SQL Statement with a 'NOT IN' Subquery in PostgreSQL ?](https://tosska.com/how-many-ways-can-you-tune-an-sql-statement-with-a-not-in-subquery-in-postgresql/) - I’ll explore additional solutions for optimizing SQL queries that are use “NOT IN” subqueries for my recent blog post. Below is an example SQL statement with a NOT IN subquery. It retrieves records from the grade table where grd_id does not match any emp_grade in the employee table for rows with emp_id greater than 3000: select * from grade where grd_id not in (select b.emp_grade from
- [How to Tune SQL with “NOT IN subquery” for PostgreSQL ?](https://tosska.com/how-to-tune-sql-with-not-in-subquery-for-postgresql/) - Below is an example of a SQL statement using an NOT IN subquery. This query retrieves records from the Grade table where the grd_id does not match any grd_id in the employee table for rows where emp_id exceeds 3,000: select * from grade where grd_id not in (select b.emp_grade from employee b
- [How Many Ways Can You Tune an SQL Statement with an 'IN' Subquery in PostgreSQL ?](https://tosska.com/how-many-ways-can-you-tune-an-sql-statement-with-an-in-subquery-in-postgresql/) - Below is a SQL statement from my recent blog post. A reader asked about the performance impact of adding +0 to a subquery's select list (e.g., b.emp_grade+0). I was pleased to learn that this +0 solution was first introduced by me roughly 20 years ago to resolve a specific subquery issue. However, this method has
- [How to Tune SQL with “IN subquery” for PostgreSQL ?](https://tosska.com/how-to-tune-sql-with-in-subquery-for-postgresql/) - Below is an example of a SQL statement using an IN subquery. This query retrieves records from the Grade table where the grd_id matches any grd_id in the employee table for rows where emp_id exceeds 3,000,000: select * from grade where grd_id in (select b.emp_grade from employee b where b.emp_id > 3000000)
- [How to Tune SQL Statement with CASE Expression for PostgreSQL ?](https://tosska.com/how-to-tune-sql-statement-with-case-expression-for-postgresql/) - Here the following is a simple SQL statement with a CASE expression syntax. SELECT * FROM employee WHERE CASE WHEN emp_salary< 1000 THEN 'low' WHEN emp_salary>100000 THEN 'high' END = :a The following are the query plans for this SQL statement, which completes in 1.01 seconds with the bind
- [Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss 1.6.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tseg-pro-for-opengauss-1-6-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss 1.6.0 Release Notes
- [Tosska SQL Tuning Expert Pro (TSEP Pro™) for PostgreSQL® - System Requirements](https://tosska.com/tosska-sql-tuning-expert-pro-tsep-pro-for-postgresql-system-requirements/) - Before installing Tosska SQL Tuning Expert Pro (TSEP Pro™) for PostgreSQL®, please make sure your system meets the following minimum hardware and software requirements: CPU 1.8 GHz Processor Memory 2 GB of RAM minimum, 4 GB of RAM recommended Hard Disk Space 200 MB of disk space for installation Operating System Microsoft Windows® 7 Microsoft
- [Tosska SQL Tuning Expert Pro (TSEP Pro™) for PostgreSQL 1.1.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tsep-pro-for-postgresql-1-1-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSEP Pro™) for PostgreSQL 1.1.0 Release Notes
- [How to Tune SQL Statement with CASE Expression for openGauss ?](https://tosska.com/how-to-tune-sql-statement-with-case-expression-for-opengauss/) - openGauss is an open-source relational database management system (RDBMS) that originated from PostgreSQL. It is designed for high performance, high availability, and enterprise-grade features. Initially developed by Huawei, openGauss was later open sourced to the community. Here is a common problem that developers may encounter: writing a dynamic SQL statement with a CASE expression that
- [How to Tune SQL with “Exists subquery” for openGauss ?](https://tosska.com/how-to-tune-sql-with-exists-subquery-for-opengauss/) - openGauss is an open-source relational database management system (RDBMS) that originated from PostgreSQL. It is designed for high performance, high availability, and enterprise-grade features. Initially developed by Huawei, openGauss was later open sourced to the community. One common problem that often arises in most database SQL optimizers is the inefficient handling of EXISTS subqueries. Below
- [How to Tune SQL with “IN subquery” for openGauss ?](https://tosska.com/how-to-tune-sql-with-in-subquery-for-opengauss/) - openGauss is an open-source relational database management system (RDBMS) that originated from PostgreSQL. It is designed for high performance, high availability, and enterprise-grade features. Initially developed by Huawei, openGauss was later open-sourced to the community. The SQL optimizer in openGauss is based on PostgreSQL but has been significantly enhanced and modified to improve performance, scalability,
- [Tosska DB Ace Enterprise (DBAO™) for Oracle 3.2.0 Release Notes](https://tosska.com/tosska-db-ace-enterprise-dbao-for-oracle-3-2-0-release-notes/) - Click to view Tosska DB Ace Enterprise (DBAO™) for Oracle 3.2.0 Release Notes
- [Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss 1.5.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tseg-pro-for-opengauss-1-5-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss 1.5.0 Release Notes
- [How to use Query Rewriter Plugin to tune SQL in MySQL database II](https://tosska.com/how-to-use-query-rewriter-plugin-to-tune-sql-in-mysql-database-ii/) - The Query Rewriter Plugin in MySQL is a component that allows you to modify incoming SQL queries before execution. It provides the ability to transform, route, filter, or expand queries based on specific requirements. If you have installed the plugin, the following SQL statements can be used to define your SQL replacement rules and error
- [How to use Query Rewriter Plugin to tune SQL in MySQL database I](https://tosska.com/how-to-use-query-rewriter-plugin-to-tune-sql-in-mysql-database-i/) - The Query Rewriter Plugin in MySQL is a component that allows you to modify incoming SQL queries before execution. It provides the ability to transform, route, filter, or expand queries based on specific requirements. This plugin operates at the SQL layer and can be utilized for optimizing query performance, enforcing security policies, implementing data partitioning
- [Tosska DB Ace Enterprise (DBAS™) for SQL Server® - System Requirements](https://tosska.com/tosska-db-ace-enterprise-dbas-for-sql-server-system-requirements/) - Before installing Tosska DB Ace Enterprise (DBAS™) for SQL Server®, please make sure your system meets the following minimum hardware and software requirements: CPU 1.8 GHz Processor Memory 2 GB of RAM minimum, 4 GB of RAM recommended Hard Disk Space 500 MB of disk space for 64-bit installation Operating System Microsoft Windows® 7 64-bit
- [Tosska DB Ace Enterprise (DBAS™) for SQL Server 2.1.1 Release Notes](https://tosska.com/tosska-db-ace-enterprise-dbas-for-sql-server-2-1-1-release-notes/) - Click to view Tosska DB Ace Enterprise (DBAS™) for SQL Server 2.1.1 Release Notes
- [Tosska DB Ace Enterprise (DBAM™) for MySQL 2.0.0 Release Notes](https://tosska.com/tosska-db-ace-enterprise-dbam-for-mysql-2-0-0-release-notes/) - Click to view Tosska DB Ace Enterprise (DBAM™) for MySQL 2.0.0 Release Notes
- [How to tune SQL in a Database Object with Plan Guide for SQL Server ?](https://tosska.com/how-to-tune-sql-in-a-database-object-with-plan-guide-for-sql-server/) - Leveraging Plan Guides in MS SQL Server can prove beneficial for optimizing the performance of a particular query within database objects like stored procedures and trigger applications. This technique allows you to enhance query efficiency without requiring modifications to the application's source code. Here are the steps to use Plan Guides to tune third-party applications
- [How to tune Ad-hoc SQL with Plan Guide for SQL Server ?](https://tosska.com/how-to-tune-ad-hoc-sql-with-plan-guide-for-sql-server/) - Using Plan Guides to tune third-party applications SQL in MS SQL Server can be a useful technique when you need to optimize the performance of a specific query or set of queries generated by the application, without making changes to the application's source code. Here are the steps to use Plan Guides to tune third-party
- [The Overlooked Significance of Performance Deployment in Software Deployment](https://tosska.com/the-overlooked-significance-of-performance-deployment-in-software-deployment/) - Performance deployment is a critical aspect of software deployment that is often undervalued. While it's important to ensure that software is deployed correctly, it's equally important to optimize its performance in the production environment. By recognizing the significance of performance deployment during the software deployment process, developers can ensure that their software performs well and
- [How to analyze the performance impact of a database environment change using what-if analysis ?](https://tosska.com/how-to-analyze-the-performance-impact-of-a-database-environment-change-using-what-if-analysis/) - To properly evaluate the impact of a set of SQL statements during a database environment change, it's crucial to have a thorough understanding of how SQL query performance can be impacted. There are two primary types of performance changes that can occur in SQL queries. The first type, which I refer to as "progressive change,"
- [An Example to Show How to Tune SQL with Query Store for SQL Server](https://tosska.com/an-example-to-show-how-to-tune-sql-with-query-store-for-sql-server/) - The Query Store feature in SQL Server serves as a valuable tool for troubleshooting performance issues by allowing users to quickly identify performance degradation caused by changes to query plans. For example, when the following SQL statement is executed in SSMS, it takes 15,579 ms to finish. Using the Top Resource Consuming Queries feature in
- [How to tune SQL with Query Store for SQL Server ?](https://tosska.com/how-to-tune-sql-with-query-store-for-sql-server/) - The Query Store feature in SQL Server serves as a valuable tool for troubleshooting performance issues by allowing users to quickly identify performance degradation caused by changes to query plans. In the given example, we can observe a SQL query (ID 23058) that has two query plans. The yellow dot corresponds to a query plan
- [Tosska DB Ace Enterprise (DBAS™) for SQL Server 2.1.0 Release Notes](https://tosska.com/tosska-db-ace-enterprise-dbas-for-sql-server-2-1-0-release-notes/) - Click to view Tosska DB Ace Enterprise (DBAS™) for SQL Server 2.1.0 Release Notes
- [How To Use 80/20 Rule To Tune A Database Application II ?](https://tosska.com/how-to-use-80-20-rule-to-tune-a-database-application-ii/) - The previous article “How To Use 80/20 Rule To Tune A Database Application I “ demonstrated how the 80/20 Rule can be applied to evaluate the overall performance of SQL workload in a database. In this example, a set of 90 SQL statements retrieved from Oracle SGA is presented in a chart that lists each
- [How To Use 80/20 Rule To Tune A Database Application I ?](https://tosska.com/how-to-use-80-20-rule-to-tune-a-database-application-i/) - In 2002, Microsoft reported that the majority of errors and crashes in their software were caused by a minority of the bugs they detected, specifically about 20%. This phenomenon, known as the Pareto principle or the eighty-twenty rule, is also relevant to the analysis of database SQL behavior. It is assumed that only 20% of
- [How to Tune SQL with DB Link for Oracle II ?](https://tosska.com/how-to-tune-sql-with-db-link-for-oracle-ii/) - Here is an example SQL, the query is retrieving employee, department, and grade tables from the remote database @richdb SELECT * FROM emp_subsidiary@richdb a, department@richdb, grade@richdb WHERE emp_grade < 1200 AND emp_dept = dpt_id AND emp_grade = grd_id ORDER BY emp_id Here the following is the query plan of this SQL,
- [Tosska SQL Tuning Expert Pro (TSE Pro™) 4.8.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-4-8-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 4.8.0 Release Notes
- [How to Tune SQL with DB Link for Oracle I?](https://tosska.com/how-to-tune-sql-with-db-link-for-oracle-i/) - Here is an example SQL query used to calculate the average salary of employees on the remote database @richdb in each department in the local database whose department name starts with the letter "D". SELECT Avg(emp_salary), emp_dept FROM employee@richdb WHERE emp_dept IN (SELECT dpt_id FROM department WHERE dpt_name LIKE 'D%') GROUP BY
- [Tosska DB Ace Enterprise (DBAO™) for Oracle 1.3.0 Release Notes](https://tosska.com/tosska-db-ace-enterprise-dbao-for-oracle-1-3-0-release-notes/) - Click to view Tosska DB Ace Enterprise (DBAO™) for Oracle 1.3.0 Release Notes
- [Tosska DB Ace Enterprise (DBAO™) for Oracle 2.0.0 Release Notes](https://tosska.com/tosska-db-ace-enterprise-dbao-for-oracle-2-0-0-release-notes/) - Click to view Tosska DB Ace Enterprise (DBAO™) for Oracle 2.0.0 Release Notes
- [Tosska DB Ace Enterprise (DBAO™) for Oracle 2.0.1 Release Notes](https://tosska.com/tosska-db-ace-enterprise-dbao-for-oracle-2-0-1-release-notes/) - Click to view Tosska DB Ace Enterprise (DBAO™) for Oracle 2.0.1 Release Notes
- [Tosska DB Ace Enterprise (DBAO™) for Oracle 2.1.1 Release Notes](https://tosska.com/tosska-db-ace-enterprise-dbao-for-oracle-2-1-1-release-notes/) - Click to view Tosska DB Ace Enterprise (DBAO™) for Oracle 2.1.1 Release Notes
- [Tosska DB Ace Enterprise (DBAO™) for Oracle 3.0.0 Release Notes](https://tosska.com/tosska-db-ace-enterprise-dbao-for-oracle-3-0-0-release-notes/) - Click to view Tosska DB Ace Enterprise (DBAO™) for Oracle 3.0.0 Release Notes
- [How to tune Oracle application packages’ SQL without touching source code](https://tosska.com/how-to-tune-oracle-application-packages-sql/) - Introduction Application package software is a collection of software programs that is developed for the purpose of being licensed to third-party organizations. Although a package software may be tailored for a user's specific needs through parameters or tables, the software itself is not developed specifically for an organization. So, users do not own the source
- [Tackling Large Tables to Improve MySQL Database Performance](https://tosska.com/tackling-large-tables-to-improve-mysql-database-performance-2/) - Oftentimes, database professionals make the mistake of jumping to conclusions when trying to improve MySQL database performance. They assume that the database must be the reason why the application has slowed down. In most cases, they may be right- which is why it’s important to start looking for possible bottlenecks and removing them to reduce
- [Don’t Overlook Oracle Database and SQL Performance: Here’s why](https://tosska.com/oracle-database-and-sql-performance-tuning/) - Being a DBA is not always a fun job, thanks to certain time-consuming tasks that it entails. One of these is to ensure optimal Oracle database and SQL performance. Typically, it is done by spending a lot of time tuning the long list of SQL statements and software code in order to improve efficiency and
- [Improve Oracle Database Performance Tuning with Tosska’s AI-Enabled Tools](https://tosska.com/improve-oracle-database-performance-tuning/) - Oracle database performance tuning is a crucial method for accelerating the application function and data retrieval process. In order to speed up the performance of the application, the developer or the database administrator has to expedite query response time. This implies that they must have a deep understanding of how well the database is organized
- [SQL Plan Management Oracle - All You Need to Know About](https://tosska.com/sql-query-optimization-tool-and-plan-management/) - While upgrading the Oracle database or making any changes in the system parameters, you might have noticed that some SQLs’ performance or queries get highly regressed. If this happens, then don’t worry it’s quite obvious and will always happen whenever there are any changes in the plan. But you can prevent this regression if you
- [Oracle Database and SQL: Tips for MySQL Database Performance Tuning](https://tosska.com/oracle-database-and-sql/) - Until now we have learned a lot about Oracle database and SQL performance tuning. Now, let’s discuss MySQL database performance tuning. Just like any other relational database, MySQL could also be a nightmare to many. It can crawl to a halt at a moment’s notice and in the next moment, you will find it leaving
- [Improve Performance Tuning in SQL MySQL Through Multiple Parameters](https://tosska.com/performance-tuning-in-sql-mysql/) - MySQL tuning is no trivial task - it takes some work. However, Database Administrators know that there are a few parameters through which they can greatly enhance the speed and output of the database. If you are in search of ways to improve performance tuning in sql MySQL , you will find some of the
- [Analyzing the Inner Works of MySQL SQL Performance Tuning and Oracle Database](https://tosska.com/mysql-database-and-sql/) - When it comes to MySQL, slow performance in large tables is one of the main sources of complaints. It is true that some users face problems as their database fails to sufficiently handle a more than a certain number of rows. However, there also are many corporations that use MySQL for millions, even billions of
- [Improve MySQL Database Performance by Controlling Partitions](https://tosska.com/improve-mysql-database-performance/) - If you have been dealing with large MySQL data for a while, you may have faced an interesting case like this at some point - one which involves a table with data merged with INSERT IN DUPLICATE KEY queries. Even if you haven’t faced such a situation so far, you may be able to tell
- [MySQL SQL Performance Tuning: Confusing MySQL Server Variables](https://tosska.com/mysql-sql-performance-tuning-confusing-mysql-server-variables/) - MySQL Server contains a wide variety of variables that can be modified according to different uses or to enhance performance. However, despite their detailed documentation, there is plenty of confusion regarding which of these variables are suitable only for storage engines and which ones are utilized on SQL layer, and are applicable for all storage
- [Why DBA Tuning for Oracle SQL Query is Crucial in Databases](https://tosska.com/sql-optimizer-for-sql-server-and-dba-tuning/) - SQL tuning is an extensive topic in itself that deserves coverage in books dedicated to stored programming. This is because it is considered as a vital skill for those who create stored programs in MySQL or Oracle. There are several other reasons as well, which we will discuss in this blog. DBA Tuning of SQL
- [How You Need Tuning to Improve MySQL Database Performance](https://tosska.com/optimization-of-sql-queries/) - SQL performance tuning is about saving you a great deal of money by improving various aspects of database management. Be it changing inefficient queries or replacing unnecessarily large indexes, tuning your database can really help you regulate your expenses. SQL tuning will not only improve MySQL database performance, but it will also help you save
- [Improve Performance of SQL Query with these Great Techniques](https://tosska.com/sql-performance-monitoring-improve-performance-of-sql-query/) - SQL performance tuning can be an extremely complicated task, especially where data in huge quantities is concerned. When implementing queries to insert data in large quantities, even the tiniest of changes can have a major impact on performance - for better or for worse. If you are new to databases, you may be wondering what
- [What Optimization in SQL is, and Why It’s Necessary for DBAs](https://tosska.com/mysql-query-optimization-in-sql/) - SQL statements or queries are designed to retrieve information from the database. A user can achieve the same results through optimization in SQL; using a tuned query is especially useful from an execution perspective. Tuning a database is a vital step in organizing and accessing the information in a database. Performance tuning in SQL requires
- [Optimization in SQL: The Importance of Automated Tuning](https://tosska.com/optimization-in-sql/) - Structured data is going to last, despite the growing prevalence and importance of unstructured data. In fact, it is foreseen as one of the biggest time-consumers for Database Administrators, at least for the discernable future. Structured data also requires to be accessed, and SQL is the chief access method, which means professionals will rely on
- [Improve SQL Queries & Database for Better Efficiency: Part 1](https://tosska.com/improve-database-for-better-efficiency-part-1/) - SQL is probably the most popular and powerful means to handle data, but sometimes you need actionable advice to unleash its power and make the most of such a robust language. In case you’re operating in the absence of a data warehouse or a segregated analytical database for assessment, you may be able to gain
- [Optimization in SQL: Determining Stale Statistics in Oracle](https://tosska.com/optimization-in-sql-determining-stale-statistics-in-oracle/) - You can determine whether statistics are stale in Oracle using two methods. The first is to make Oracle tell you if it considers the stats are stale. The second involves a comparison of the statistics of what the DBMS assumes a table to be - and what it really is. Here, we’ll help you understand
- [Query Performance Tuning: Making an SQL Monitor Report](https://tosska.com/query-performance-tuning-making-an-sql-monitor-report/) - Creating a SQL Monitor Report plays an important role in database optimization as it helps the user observe other occurrences during the execution of long-running statements. In this post, we’ll discuss how to create one such report that may help you during query performance tuning. SQL Monitor Report: Bringing DBAs One Step Closer to Database
- [SQL Performance Tuning: Frequent Questions about Indexes](https://tosska.com/sql-performance-tuning/) - A database is a piece of software operating on a computer, which means it is dependent and likely to face the same limitations as other software present on that computer. In other words, it will only be able to process as much data as the hardware can handle. One of the best ways to speed
- [MySQL SQL Performance Tuning: 8 Great Monitoring Practices](https://tosska.com/mysql-sql-performance-tuning/) - DBAs don’t mind getting the attention of the management, as long as it’s for a positive reason. I mean once in a while, but not all the time; many would still prefer to remain off-radar, quietly ensuring the organization’s databases stay running without a hitch. Since they have significant accountability in an organization, it is
- [6 Query Related Problems to Avoid in Oracle Database](https://tosska.com/6-query-related-problems-to-avoid-in-oracle-sql-query/) - Insufficient database performance is a fly in every DBA’s ointment. To make matters worse, finding the root cause of performance-related problems can get really difficult. One of the best methods to get rid of performance issues is through performance tuning. However, you may not always be sure where to begin with the optimization process. At
- [Optimization in SQL: Answering 4 Commonly-Asked Questions](https://tosska.com/optimization-in-sql-answering-4-commonly-asked-questions/) - A SQL query or statement is tasked with fetching the required information from the database. While the same output can be gained from different statements, they are likely to work at different performance levels. The difference in performance output makes a lot of difference because a millisecond of lapse in query execution can result in
- [5 Chief Oracle SQL Performance Tuning Methodologies](https://tosska.com/5-chief-oracle-sql-performance-tuning-methodologies/) - Nearly every organization in the present era stores its information in separate databases depending on their specifications. Soft copies are given greater preference due to advancements in storage technology, making databases - and their performance - important in the day-to-day operations of an organization. Therefore, DBAs conduct regular checks and Oracle SQL performance tuning to
- [Downloaded Free SQL Server? Maintain its Health, Too](https://tosska.com/download-free-sql-server/) - Ensuring the optimal health of a database is vital to maintain ongoing operations. As a Database Administrator, this is one of the main tasks associated with database performance. Although it may sound challenging given the complex operations involved, there are simpler ways to achieve this without expending significant time and energy. Here, we’ll briefly explain
- [Using Free SQL Tools for Windows to Monitor Your Database](https://tosska.com/using-free-sql-tools-for-windows/) - There are several reasons why SQL monitoring is a must, especially for organizational databases. However, you need to understand those reasons to know the importance of regular database maintenance. SQL tools have a prominent role to play in this, and while some of them may cost money, there are several free SQL tools for Windows
- [5 Reasons Why a Hardware Upgrade can Worsen Performance](https://tosska.com/5-reasons-why-a-hardware-upgrade-can-worsen-performance/) - After gaining approval to switch to new hardware (at last) and a newer SQL Server version, you start to make preparations. But what will you do if the performance worsens after you finally do the migration? Hardware upgrades are often preferred over MySQL SQL performance tuning but the transition may not necessarily take place smoothly.
- [SQL Query Optimization Tool Online: Top Characteristics](https://tosska.com/sql-query-optimization-tool-online-top-characteristics/) - Data is one of the most important resources in an organization and SQL is the most popular method to store and manipulate it. Therefore, the widely-used Structured Query Language is supported by almost every modern RDBMS around the world. This is also why database servers are often known as SQL Servers, where the language establishes
- [Oracle Database and SQL: The Pros & Cons of Bind Variables](https://tosska.com/oracle-database-and-sql-the-pros-cons-of-bind-variables/) - Bind Variables are typically considered as one of the major aspects of enhanced SQL query performance. According to Oracle documentation, they serve as a placeholder in a SQL query, getting replaced by a particular value that helps in statement execution. The use of these variables enables users to create statements that can receive time-running parameters
- [5 Essential Paid & Free SQL Tools for Windows SQL Database](https://tosska.com/5-essential-paid-free-sql-tools-for-windows-sql-database/) - Effective database management requires one or more tools regardless of the platform your databases run on. The benefit of these tools is, whether they are operating on Windows, macOS, Linux, or the cloud, the tools mentioned below don’t require the same platform as the databases. Thanks to plenty of choices when it comes to SQL
- [Selecting a SQL Server Database Version for Your Company](https://tosska.com/selecting-a-sql-server-database-version-for-your-company/) - Choosing the right version of SQL Server is important for the performance you desire. If you're installing an older one because your organization’s management prefers an older build or the vendor is unable to support newer versions, it is important to let them know which version your company needs, and why. For this reason, we
- [Optimization of SQL Queries: Database Engine Tuning Advisor](https://tosska.com/optimization-of-sql-queries-database-engine-tuning-advisor/) - If there is one complaint business users may have about their production database, it is slow performance. Database professionals, therefore, often try to focus strictly on finding out and resolving the source of the issue in the database. The Database Engine Tuning Advisor (DTA) is one of the best tools in this regard. It helps
- [SQL Query Performance Tuning: A Look at Various Plan Formats](https://tosska.com/sql-query-performance-tuning-a-look-at-various-plan-formats/) - Database professionals are often familiar with the fundamental maintenance tasks for SQL Server. However, they may have to perform the optimization of SQL queries and keep an eye on query plans from time to time. This may lead to confusion as to which type of query plan they should use. Here, we will cover the
- [SQL Performance Tuning: 5 Things to Do for Faster Results](https://tosska.com/sql-performance-tuning-5-things-to-do-for-faster-results/) - Is your SQL Server falling behind in terms of performance? Are poorly-written queries slowing down your applications? Before you set out in search of professional help, make sure you’ve tried everything you could to resolve the issues you’re facing on your database. Many problems related to SQL Server can be handled easily with preventative maintenance,
- [Make Your Oracle Database Work Faster with these 6 Methods](https://tosska.com/improve-performance-of-sql-query/) - Every Oracle database admin dreads the day when they receive a flurry of complaint calls from users regarding slow online performance. That’s why, if you’re responsible for managing database performance in your organization, you’ll want to ensure this doesn’t happen. How? By preparing your infrastructure to handle increased loads. Supporting it with performance tuning is
- [Importance of Backup & Recovery in MySQL Database and SQL](https://tosska.com/backup-recovery-in-mysql-database-and-sql/) - A database is the cornerstone of any application. For this reason, maintaining one or more backup and recovery options remains a priority for every database professional. There are multiple alternatives you can choose from as per the specific needs of your organization’s database. In this post, we will examine some of the most popular back-ups
- [The Importance of Query Optimization in SQL Server Plus Tips](https://tosska.com/query-optimization-in-sql-server/) - The database is a vital part of a majority of IT systems as it contains that data that needs to be processed for utilization. SQL is the standard language for fetching data from the database using queries and query optimization in SQL Server helps maintain database performance. The queries used to communicate with the database
- [Creating an Index in Oracle, and the Best Way to Make Use of It](https://tosska.com/create-index-oracle/) - Indexes are among the most useful and underutilized components of SQL. The user can create an Oracle index and store values along with their location in it. Similar to the index at the end of a book, an index enables the user to go straight to the data they are interested in. Indexes are most
- [Backup and Recovery in SQL Server: Understanding the Basics (Part 1)](https://tosska.com/backup-and-recovery-in-sql-server/) - Taking regular database backups is essential to provide assistance to businesses recovering from an unplanned event. They enable data restoration from when it was previously saved. Moreover, keeping a copy of the information separately is also vital for protection against corruption or data loss. In this 2-part series, we’ll cover In this guide, we will
- [Backup and Recovery in SQL Server: Understanding the Basics (Part 2)](https://tosska.com/backup-and-recovery-in-sql-server-understanding-the-basics/) - This blog is the continuation of the 2-part series to explain recovery models in SQL Server. Each of these aims at different requirements to provide partial or complete data recovery. The Database Administrator selects the recovery model depending on the resource and data requirements of the organization. The goal of the recovery model is to
- [The Importance of Disk Operations in Query Performance Tuning](https://tosska.com/operations-in-query-performance-tuning/) - DBAs can’t ignore disk operations when working on query performance tuning. When talking about databases, ‘disk’ may be called by one of its many names, such as ‘storage’, ‘I\O’, ‘Reads’, or disk operations. Although database professionals know all these terms mean the same thing, these might confuse those outside this field. When referring to one
- [Tackling Large Tables to Improve MySQL Database Performance](https://tosska.com/tackling-large-tables-to-improve-mysql-database-performance/) - Oftentimes, database professionals make the mistake of jumping to conclusions when trying to improve MySQL database performance. They assume that the database must be the reason why the application has slowed down. In most cases, they may be right- which is why it’s important to start looking for possible bottlenecks and removing them to reduce
- [SQL Server: Knowing How Heaps and Clustered Indexes Work](https://tosska.com/sql-server-knowing-how-heaps-and-clustered-indexes-work/) - Heaps and clustered indexes are two different ways of storing data in SQL Server. Both have their advantages and disadvantages, and we will discuss them in this post. A Bit about Heaps Heaps are essentially piles of data that remain unsorted or unorganized, hence the name. Although you can find heaps on tables that don’t
- [Transferring Data in SQL Server with an Eye on Performance](https://tosska.com/transferring-data-in-sql-server-with-an-eye-on-performance/) - A lot of database professionals often need to archive older data in SQL Server by transferring it from one table to another. There are multiple ways to achieve the transfer, the most useful of which we will discuss in this blog. We will also provide tips to ensure the performance of the database doesn’t get
- [Why You Must Speed Up Slow Queries in Oracle Database and SQL](https://tosska.com/why-you-must-speed-up-slow-queries-in-oracle-database-and-sql/) - The performance of an Oracle database and SQL query speed can directly affect the organisation it belongs to. If the queries running in the database are slow, they will surely have a negative impact. However, its severity may vary based on the database’s role, its architecture, and the industry your organisation operates in. Regardless of
- [A Quick Guide to Stored Procedures in Oracle Database and SQL](https://tosska.com/a-quick-guide-to-stored-procedures-in-oracle-database-and-sql/) - Stored procedures are increasing in popularity in Oracle Database and SQL Server because of quicker execution. Earlier, application code mostly resided in external programs. However, its shift toward database engine interiors compels database professionals to keep their memory requirements in mind. This is as necessary as planning for times when the code related to database
- [Measures to Improve Performance of SQL Query?](https://tosska.com/measures-to-improve-performance-of-sql-query/) - That's not bad enough that you call it SQL whereas your boss pronounces it ‘sequel’. But also, you now suffer from "Super Slow Query Syndrome," and sometimes, your questions bomb without effect. Don't worry. We have your back. We recently had a powwow with a lot of caffeine to think about our favorite tips to
- [How to Tune SQL with IN Subquery with Intersect for Oracle?](https://tosska.com/how-to-tune-sql-with-in-subquery-with-intersect-for-oracle/) - Here is an example SQL that retrieves data from EMPLOYEE and DEPARTMENT table with the employee’s grade code in the GRADE table. SELECT emp_id, emp_name, dpt_name FROM employee, department WHERE emp_dept = dpt_id AND emp_grade IN (SELECT grd_id FROM grade WHERE grd_min_salary < 200000) and emp_dept < 'D' Here the following is the query plan of this SQL, it
- [Tosska SQL Tuning Expert  (TSEM™) for MySQL 2.3.2 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tsem-for-mysql-2-3-2-release-notes/) - Click to view Tosska SQL Tuning Expert (TSEM™) for MySQL 2.3.2 Release Notes
- [How to Tune SQL Statement with CASE Expression by Hints Injection for Oracle?](https://tosska.com/how-to-tune-sql-statement-with-case-expression-by-hints-injection-for-oracle/) - Here the following is a simple SQL statement with a CASE expression syntax. SELECT * FROM employee WHERE CASE WHEN emp_salary< 1000 THEN 'low' WHEN emp_salary>100000 THEN 'high' ELSE 'Normal' END = 'low' Here the following are the query plans of this SQL, it takes 4.64 seconds to finish. The query shows a Full Table Scan of the EMPLOYEE table due to
- [How to Tune SQL Statement with LCASE function on index field?](https://tosska.com/how-to-tune-sql-statement-with-lcase-function-on-index-field/) - Some business requirements may need to compare the lower case of an indexed column to a given string as a data retrieval criterion. Here is an example SQL that retrieves records from the EMPLOYEE table employee if the lower case of the name is equal to the string ‘richard’. select * from employee where LCASE(emp_name)='richard' Here the following
- [Tosska SQL Tuning Expert  (TSE™)  4.6.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tse-4-6-0-release-notes/) - Click to view Tosska SQL Tuning Expert (TSE™) 4.6.0 Release Notes
- [Tosska SQL Tuning Expert Pro (TSE Pro™)  4.6.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-4-6-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 4.6.0 Release Notes
- [How to build indexes for multiple Max() functions for SQL Server?](https://tosska.com/how-to-build-indexes-for-multiple-max-functions-for-sql-server-2/) - For some SQL statements with multiple Max() functions in the select list and nothing in the Where clause, we have different methods to create new indexes to improve the SQL speed. Here is an example SQL, it is to retrieve the maximum name and age from the employee table. select max(emp_name), max(emp_age) from employee The following
- [How to use ROWID to improve an UPDATE statement for Oracle?](https://tosska.com/how-to-use-rowid-to-improve-an-update-statement-for-oracle/) - Here the following is an Update SQL with a subquery that updates the EMPLOYEE table if the emp_dept satisfies the records returned from a subquery. update employee set emp_name = 'testing' where emp_dept IN (select dpt_id from department where dpt_name like 'A%') and emp_grade>2000 You can see Oracle uses a Hash join of the DEPARTMENT table and EMPLOYEE
- [Tosska SQL Tuning Expert  (TSE™)  4.5.1 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tse-4-5-1-release-notes/) - Click to view Tosska SQL Tuning Expert (TSE™) 4.5.1 Release Notes
- [Tosska SQL Tuning Expert Pro (TSE Pro™) 4.5.1 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-4-5-1-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 4.5.1 Release Notes
- [How to build indexes for slow first execution SQL - SQL Server?](https://tosska.com/how-to-build-indexes-for-slow-first-execution-sql-sql-server/) - You may suffer from SQL statements with a slow first execution time due to the long data cache process. The following SQL is simple that retrieves records from the EMPLOYEE table that if EMP_SALARY < 500000 and the result set is ordered by EMP_NAME. Select emp_id, emp_name, emp_salary, emp_address, emp_telephone from employee where emp_salary < 500000 order
- [How to index SQL with aggregate function SQL for Oracle?](https://tosska.com/how-to-index-sql-with-aggregate-function-sql-for-oracle/) - Here the following is an example SQL shows you that select the maximum emp_address which is not indexed in the EMPLOYEE table with 3 million records, the emp_grade is an indexed column. select max(emp_address) from employee a where emp_grade
- [Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server 2.1.1 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tses-pro-for-sql-server-2-1-1-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server 2.1.1 Release Notes
- [Tosska SQL Tuning Expert  (TSES™) for SQL Server 1.5.1 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tses-for-sql-server-1-5-1-release-notes/) - Click to view Tosska SQL Tuning Expert (TSES™) for SQL Server 1.5.1 Release Notes
- [How to Tune SQL Statement with CASE Expression for SQL Server II?](https://tosska.com/how-to-tune-sql-statement-with-case-expression-for-sql-server-ii/) - We have discussed how to tune a CASE expression SQL with hardcoded literals in my last blog: How to Tune SQL Statement with CASE Expression for SQL Server I? SELECT * FROM EMPLOYEE WHERE CASE when emp_id < 1001000 then 'Old Employee' when emp_dept
- [How to Tune SQL Statements with NO_RANGE_OPTIMIZATION Hints Injection?](https://tosska.com/how-to-tune-sql-statements-with-no_range_optimization-hints-injection/) - There are some SQL statements with performance problem can be tuned by Hints injection only. Here is an example to show you how to use NO_RANGE_OPTIMIZATION optimization hints to tune a SQL statement. A simple example SQL that retrieves data from EMPLOYEE and EMP_SAL_HIST tables. select * from employee a,emp_sal_hist h where a.emp_id =h.sal_emp_id and
- [How to use ORDERED Hint to Tune a SQL with subquery for Oracle?](https://tosska.com/how-to-use-ordered-hint-to-tune-a-sql-with-subquery-for-oracle/) - Here the following is the description of the ORDERED hint. The ORDERED hint causes Oracle to join tables in the order in which they appear in the FROM clause. If you omit the ORDERED hint from a SQL statement performing a join, then the optimizer chooses the order in which to join the tables. You
- [Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server 2.0.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tses-pro-for-sql-server-2-0-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server 2.0.0 Release Notes
- [Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server® - System Requirements](https://tosska.com/tosska-sql-tuning-expert-pro-tses-pro-for-sql-server-system-requirements/) - Before installing Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server®, please make sure your system meets the following minimum hardware and software requirements: CPU 1.8 GHz Processor Memory 2 GB of RAM minimum, 4 GB of RAM recommended Hard Disk Space 500 MB of disk space for 64-bit installation Operating System Microsoft
- [Do not undermine your SQL Server’s potential ability](https://tosska.com/do-not-undermine-your-sql-servers-potential-ability/) - For some SQL statements that are failed to be tuned by syntax rewrite, hints injection, and all necessary indexes are built, people may think that hardware upgrade is the only way to resolve the performance problem. But, please don’t undermine your SQL Server’s SQL optimizer which can provide you with the ultimate performance solution that
- [How is the order of the columns in a composite index affecting a subquery performance for Oracle?](https://tosska.com/how-is-the-order-of-the-columns-in-a-composite-index-affecting-a-subquery-performance-for-oracle/) - We know the order of the columns in a composite index will determine the usage of the index or not against a table. A query will use a composite index only if the where clause of the query has at least the leading/left-most columns of the index in it. But, it is far more complicated
- [Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server 2.1.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tses-pro-for-sql-server-2-1-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server 2.1.0 Release Notes
- [How to build indexes for multiple Max() functions for SQL Server?](https://tosska.com/how-to-build-indexes-for-multiple-max-functions-for-sql-server/) - For some SQL statements with multiple Max() functions in the select list and nothing in the Where clause, we have different methods to create new indexes to improve the SQL speed. Here is an example SQL, it is to retrieve the maximum name and age from the employee table. select max(emp_name), max(emp_age) from employee The following is
- [How to use FORCE INDEX Hints to tune an UPDATE SQL statement?](https://tosska.com/how-to-use-force-index-hints-to-tune-an-update-sql-statement/) - We used to use FORCE INDEX hints to enable an index search for a SQL statement if a specific index is not used. It is due to the database SQL optimizer thinking that not using the specific index will perform better. But enabling an index is not as simple as just adding an index search
- [Tosska SQL Tuning Expert  (TSE™)  4.5.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tse-4-5-0-release-notes/) - Click to view Tosska SQL Tuning Expert (TSE™) 4.5.0 Release Notes
- [Tosska SQL Tuning Expert Pro (TSE Pro™) 4.5.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-4-5-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 4.5.0 Release Notes
- [How to Tune SQL Statement with CASE Expression for SQL Server I?](https://tosska.com/how-to-tune-sql-statement-with-case-expression-for-sql-server-i-2/) - Here the following is a simple SQL statement with a CASE expression syntax. SELECT * FROM EMPLOYEE WHERE CASE when emp_id < 1001000 then 'Old Employee' when emp_dept
- [How to Tune SQL Statement with CASE Expression for SQL Server I?](https://tosska.com/how-to-tune-sql-statement-with-case-expression-for-sql-server-i/) - Here the following is a simple SQL statement with a CASE expression syntax. SELECT * FROM EMPLOYEE WHERE CASE when emp_id < 1001000 then 'Old Employee' when emp_dept
- [How to tune a SQL that cannot be tuned ?](https://tosska.com/how-to-tune-a-sql-that-cannot-be-tuned/) - Some mission-critical SQL statements are already reached their maximum speed within the current indexes configuration. It means that those SQL statements are not able to be improved by syntax rewrite or Hints injection. Most people may think that the only way to improve this kind of SQL may be by upgrading hardware. For example, the
- [Tosska SQL Tuning Expert Pro (TSE Pro™) 4.4.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-4-4-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 4.4.0 Release Notes
- [How to Tune SQL Statements with Rewrite and Hints Injection for MySQL?](https://tosska.com/how-to-tune-sql-statements-with-rewrite-and-hints-injection-for-mysql/) - There are some SQL statements with performance problem have to be tuned by SQL syntax rewrite and Hints injection, it is a little bit difficult for SQL tuning newcomers to master this technique. Developers not only have to understand the relationship between SQL syntax and the final query plan generation but have to understand the
- [How to Tune SQL Statement with OR conditions in a Subquery for SQL Server?](https://tosska.com/how-to-tune-sql-statement-with-or-conditions-in-a-subquery-for-sql-server/) - The following is an example that shows a SQL statement with an EXISTS subquery. The SQL counts the records from the EMPLOYEE table if the OR conditions are satisfied in the subquery of the DEPARTMENT table. select countn(*) from employee a where exists (select 'x' from department b where a.emp_id=b.dpt_manager or a.emp_salary=b.dpt_avg_salary ) Here the
- [How to Tune SQL Statements to Run SLOWER… but Make Users Feel BETTER (Oracle)?](https://tosska.com/how-to-tune-sql-statements-to-run-slower-but-make-users-feel-better-oracle/) - Your end-users may keep on complaining about some functions of their database application are running slow, but you may found that those SQL statements are already reached their maximum speed in the current Oracle and hardware configuration. There may be no way to improve the SQL unless you are willing to upgrade your hardware. To
- [Tosska SQL Tuning Expert  (TSES™) for SQL Server 1.5.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tses-for-sql-server-1-5-0-release-notes/) - Click to view Tosska SQL Tuning Expert (TSES™) for SQL Server 1.5.0 Release Notes
- [Tosska SQL Tuning Expert  for MySQL <small>(5.1-5.5)</small> (TSEM5™) 2.3.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-for-mysql-5-1-5-5-tsem5-2-3-0-release-notes/) - Click to view Tosska SQL Tuning Expert for MySQL (5.1-5.5) (TSEM5™) 2.3.0 Release Notes
- [Tosska SQL Tuning Expert (TSES™) for SQL Server® - System Requirements](https://tosska.com/tosska-sql-tuning-expert-tses-for-sql-server-system-requirements/) - Before installing Tosska SQL Tuning Expert (TSES™) for SQL Server®, please make sure your system meets the following minimum hardware and software requirements: CPU 1.8 GHz Processor Memory 2 GB of RAM minimum, 4 GB of RAM recommended Hard Disk Space 500 MB of disk space for 64-bit installation Operating System Microsoft Windows® 7
- [Tosska SQL Tuning Expert (TSEM5™) for MySQL <small>(5.1-5.5)</small>® - System Requirements](https://tosska.com/tosska-sql-tuning-expert-tsem5-for-mysql-5-1-5-5-system-requirements/) - Before installing Tosska SQL Tuning Expert (TSEM5™) for MySQL (5.1-5.5)®, please make sure your system meets the following minimum hardware and software requirements: CPU 1.8 GHz Processor Memory 2 GB of RAM minimum, 4 GB of RAM recommended Hard Disk Space 400 MB of disk space for 64-bit installation Operating System Microsoft Windows® 7
- [Tosska SQL Tuning Expert  (TSE™)  4.3.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tse-4-3-0-release-notes/) - Click to view Tosska SQL Tuning Expert (TSE™) 4.3.0 Release Notes
- [Tosska SQL Tuning Expert Pro (TSE Pro™) 4.3.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-4-3-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 4.3.0 Release Notes
- [How to Tune SQL Statement with “< ANY (subquery)” Operator for Oracle?](https://tosska.com/how-to-tune-sql-statement-with-any-subquery-operator-for-oracle/) - Here the following is a simple SQL statement with a “< ANY (Subquery)” syntax. SELECT * FROM employee WHERE emp_salary< ANY (SELECT emp_salary FROM emp_subsidiary where emp_dept='AAA' ) Here the following is the query plan of the SQL, it takes 18.49 seconds to finish. The query shows a “TABLE ACCESS FULL” of EMPLOYEE table and “MERGE JOIN SEMI” to a
- [How to Tune SQL Statements to Run SLOWER… but Make Users Feel BETTER (MySQL)?](https://tosska.com/how-to-tune-sql-statements-to-run-slower-but-make-users-feel-better-mysql/) - Your end-users may keep on complaining about some functions of their database application are running slow, but you may found that those SQL statements are already reached their maximum speed in the current MySQL and hardware configuration. There may be no way to improve the SQL unless you are willing to upgrade your hardware. To
- [How to Tune Bad Performance SET ROWCOUNT SQL Statements for SQL Server?](https://tosska.com/how-to-tune-bad-performance-set-rowcount-sql-statements-for-sql-server/) - Some SQL statements will be running very slow after SET ROWCOUNT or TOP is used. SET ROWCOUNT and TOP are used to tell SQL Server to select a specific number of rows from the SQL statements instead of extracting all records. Not many people know that SQL Server will try to re-optimize your SQL statements
- [Tosska SQL Tuning Expert  (TSEM™) for MySQL 2.3.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tsem-for-mysql-2-3-0-release-notes/) - Click to view Tosska SQL Tuning Expert (TSEM™) for MySQL 2.3.0 Release Notes
- [How to Tune Cold Cache SQL Statements for SQL Server?](https://tosska.com/how-to-tune-cold-cache-sql-statements-for-sql-server/) - For SQL statements that are not executed frequently, so that the relevant data is no longer exists in the buffer cache, a cold cache will significantly affect the performance of a SQL statement. A good performance SQL for hot cache may not be performing well in a cold cache environment. Experience developers will tune their
- [How to Tune SQL Statement with EXISTS Subquery for SQL Server I ?](https://tosska.com/how-to-tune-sql-statement-with-exists-subquery-for-sql-server-i/) - The following is an example that shows a SQL statement with an Exists subquery. The SQL retrieves records from the DEPARTMENT table that DPT_ID is found in emp_dept of employee table with emp_id > 2700000. SELECT * FROM DEPARTMENT where exists (select 'x' from employee where emp_id > 2700000 and emp_dept=DPT_ID) Here the following is the
- [How to Tune SQL Statement with EXISTS Subquery for SQL Server II ?](https://tosska.com/how-to-tune-sql-statement-with-exists-subquery-for-sql-server-ii/) - In my last article that a SQL statement with an Exists subquery was improved 90 times by the following rewrite. SELECT * FROM DEPARTMENT where exists (select 'x' from employee where emp_id > 2700000 and emp_dept=DPT_ID) Query Plan: Rewritten SQL syntax: select * from DEPARTMENT where DPT_ID in (select isnull(emp_dept,emp_dept) from employee where emp_id > 2700000 group by emp_dept) Query Plan: Syntax
- [How to Tune SQL Statements with CONCAT Operator for MySQL?](https://tosska.com/how-to-tune-sql-statements-with-concat-operator-for-mysql/) - There may be some business requirements that need to compare concatenate strings and column with a given unknown length of the bind variable. Here is an example SQL that retrieves data from EMPLOYEE and DEPARTMENT tables where employee’s department ID must concatenate two strings before it is compared to an unknown length of variable @dpt_var
- [How to Tune SQL Statement with IN Operator with an Expression List for SQL Server?](https://tosska.com/how-to-tune-sql-statement-with-in-operator-with-an-expression-list-for-sql-server/) - The following is an example shows a SQL statement with an IN List expression. The SQL retrieves records from EMPLOYEE table that EMP_DEPT should match any value in a list of values. select EMP_ID from EMPLOYEE WHERE EMP_DEPT IN ('AAD','COM','AAA') AND EMP_SALARY
- [Tosska SQL Tuning Expert  (TSES™) for SQL Server 1.0.5 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tses-for-sql-server-1-0-5-release-notes/) - Click to view Tosska SQL Tuning Expert (TSES™) for SQL Server 1.0.5 Release Notes
- [How to Tune SQL statement with Transitive Dependency Improvement for MySQL?](https://tosska.com/how-to-tune-sql-statement-with-transitive-dependency-improvement-for-mysql/) - The following is an example shows a SQL statement with two conditions “emp_dept=dpt_id and emp_dept
- [How to Tune SQL Statement with DECODE Expression for Oracle?](https://tosska.com/how-to-tune-sql-statement-with-decode-expression-for-oracle/) - Here the following is an example SQL statement with a DECODE expression syntax. select * from employee where decode(emp_dept , 'AAA' , 'ADM' , 'AAB' , 'ACC' , emp_dept) = 'ADM' Here the following are the query plans of this SQL, it takes 6.41 seconds to finish. The query shows a Full Table Scan of EMPLOYEE table due to the DECODE expression cannot utilize the EMP_DEPT column’s index. We
- [How to Tune SQL Statement with Driving Path Control for MySQL?](https://tosska.com/how-to-tune-sql-statement-with-driving-path-control-for-mysql/) - The following is an example shows a SQL statement with two potential table join paths. “Employee to Department” and “Department to Employee” are potential driving paths which will be decided by MySQL SQL optimizer during SQL optimization stage. select emp_id,emp_name,dpt_avg_salary from employee ,department where emp_dept=dpt_id and emp_dept like 'A%' and dpt_id like 'A%';
- [How to Tune SQL with IN Subquery in Certain Environment for Oracle?](https://tosska.com/how-to-tune-sql-with-in-subquery-in-certain-environment-for-oracle/) - Here is an example SQL that retrieves data from EMPLOYEE table with employee’s ID code in EMP_SUBSIDIARY table. select * from employee a where a.emp_id in (select b.emp_id from emp_subsidiary b) Here the following are the query plan of this SQL, it takes 10.03 seconds to finish. The query plan is very simple
- [How to Tune SQL with Exists Operator in Certain Environment for Oracle?](https://tosska.com/how-to-tune-sql-with-exists-operator-in-certain-environment-for-oracle/) - Here is an example SQL that retrieves data from EMPLOYEE table with “emp_id < 710000” and employee’s department code exists in DEPARTMENT table. select * from employee where emp_id < 710000 and exists (select 'x' from department where dpt_id = emp_dept) Here the following are the query plan of this SQL, it takes 34.22 seconds to finish. The query
- [How to Tune SQL with SEMI JOIN by Hints INDEX_DESC Injection for Oracle?](https://tosska.com/how-to-tune-sql-with-semi-join-by-hints-index_desc-injection-for-oracle/) - Semi-join is introduced in Oracle 8.0. It provides an efficient method of performing a WHERE EXISTS or WHERE IN sub-queries. A semi-join returns one copy of each row in first table for which at least one match is found in second table, there is no need of further scanning of the second table once a
- [How to Tune SQL Statement with Multiple Union in Subquery for MySQL?](https://tosska.com/how-to-tune-sql-statement-with-multiple-union-in-subquery-for-mysql/) - The following is an example shows a SQL statement with two union operator in a subquery. The SQL retrieve records from EMPLOYEE table that EMP_ID should satisfy with the union result set from two queries in a subquery. select * from employee where emp_id IN (select emp_id from emp_subsidiary where emp_grade=1000 union select emp_id from
- [How to Tune SQL Statement with IN List Bind Variables for MySQL?](https://tosska.com/how-to-tune-sql-statement-with-in-list-bind-variables-for-mysql/) - The following is an example shows a SQL statement with a variable on the IN List operator. The SQL retrieve records from EMPLOYEE table that (EMP_ID,@1) should match any value in a set of values on the right-hand side. select * from employee where (emp_id,@1) in ((1000000,'a'),(2000000,'b'),(3000000,'c')) Here the following are the query plans in
- [How to Tune SQL Statement with Multiple OR Subqueries for Oracle?](https://tosska.com/how-to-tune-sql-statement-with-multiple-or-subqueries-for-oracle/) - Here the following is SQL statement with multiple OR subquery. SELECT * FROM employee WHERE emp_id IN (SELECT emp_id FROM emp_subsidiary where emp_dept = 'ACC') OR emp_id IN (SELECT emp_id FROM employee where emp_dept = 'COM') OR emp_id = 600000 Here the following are the query plans of this SQL, it takes 29
- [How to Tune SQL with LIKE '%ROGER%' Expression for Oracle?](https://tosska.com/how-to-tune-sql-with-like-roger-expression-for-oracle/) - The LIKE is a logical operator that determines if a character string matches a specified pattern. A pattern may include regular characters and wildcard characters. The LIKE operator is used in the WHERE clause of the SELECT, UPDATE, and DELETE statements to filter rows based on pattern matching. Here is an example SQL that retrieves
- [How to Tune Delete SQL statement with subqueries for MySQL?](https://tosska.com/how-to-tune-delete-sql-statement-with-subqueries-for-mysql/) - The following is an example shows a DELETE SQL statement with subquery. The SQL delete records from emp_subsidiary that should satisfy with three conditions shows in the following query. delete from emp_subsidiary where emp_id in (SELECT EMP_ID FROM EMPLOYEE WHERE emp_salary < 15000) and emp_dept
- [Improve SQL Queries & Database for Better Efficiency: Part 2](https://tosska.com/improve-oracle-sql-queries-database-for-better-efficiency-part-2/) - This is the second blog in our two-part series to explain the best ways to optimize your database, which is best done by enhancing the SQL queries being used. Without much ado, let’s pick up where we left off - Give Preference to WHERE, instead of HAVING (when defining filters) A query is efficient when
- [Tosska SQL Tuning Expert  (TSEM™) for MySQL 2.2.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tsem-for-mysql-2-2-0-release-notes/) - Click to view Tosska SQL Tuning Expert (TSEM™) for MySQL 2.2.0 Release Notes
- [Tosska SQL Tuning Expert Pro (TSE Pro™) 4.2.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-4-2-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 4.2.0 Release Notes
- [Tosska SQL Tuning Expert (TSE™) 4.2.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tse-4-2-0-release-notes/) - Click to view Tosska SQL Tuning Expert (TSE™) 4.2.0 Release Notes
- [Tosska SQL Tuning Expert Pro (TSE Pro™) 4.1.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-4-1-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 4.1.0 Release Notes
- [Tosska SQL Tuning Expert (TSE™) 4.1.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tse-4-1-0-release-notes/) - Click to view Tosska SQL Tuning Expert (TSE™) 4.1.0 Release Notes
- [How to Tune CTE “WITH” SQL statement?](https://tosska.com/how-to-tune-cte-with-sql-statement/) - CTE stands for common table expression. A CTE allows you to define a temporary named result set that available temporarily in the execution scope of a statement such as SELECT, INSERT, UPDATE, DELETE. The following shows an example of a CTE in MySQL: WITH cte1 AS (SELECT a, b FROM table1), cte2 AS
- [How to Tune “Not Exists” SQL statement?](https://tosska.com/how-to-tune-not-exists-sql-statement/) - The following is an example shows a SQL statement with “Not Exists” expression. The SQL retrieve records from emp_subsidiary that satisfy with the “Not Exists” subquery. select * from emp_subsidiary sub where not (exists (select 'x' from employee emp where emp.emp_salary
- [How to Tune SQL Statement with multiple MAX() functions for Oracle?](https://tosska.com/how-to-tune-sql-statement-with-multiple-max-functions-for-oracle/) - Here the following is a very simple SQL statement with two Max() functions in select list. select max(emp_salary),max(emp_id) from employee; Here the following are the query plans of this SQL, it takes 8.82 seconds to finish. The query shows a Full Table Scan of Employee table. You can see that this SQL cannot utilize index
- [How to Tune UPDATE SQL statement with IN subquery (I) ?](https://tosska.com/how-to-tune-update-sql-statement-with-in-subquery-i/) - The following is an example shows an Update SQL statement with an “IN” subquery. It updates records from emp_subsidiary that satisfies the “IN” subquery conditions. update emp_subsidiary set emp_name ='Deleted Name' where emp_dept in (select dpt_id from department where dpt_avg_salary
- [Tosska SQL Tuning Expert  (TSEM™) for MySQL 2.1.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tsem-for-mysql-2-1-0-release-notes/) - Click to view Tosska SQL Tuning Expert (TSEM™) for MySQL 2.1.0 Release Notes
- [Tosska SQL Tuning Expert Pro (TSE Pro™) 4.0.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-4-0-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 4.0.0 Release Notes
- [Tosska SQL Tuning Expert (TSE™) 4.0.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tse-4-0-0-release-notes/) - Click to view Tosska SQL Tuning Expert (TSE™) 4.0.0 Release Notes
- [How to Tune SQL with OR statements?](https://tosska.com/how-to-tune-sql-with-or-statements/) - It is common that the performance is not good if a SQL statement with OR conditions. Let’s have an example show you how to tune those SQL statements in certain situations. Here is an example SQL that extract records from EMPLOYEE table if (emp_grade < 1050 or emp_id
- [How to Tune “Order by Limit N” SQL Statement?](https://tosska.com/how-to-tune-order-by-limit-n-sql-statement/) - There may be some business requirements that need to retrieve the first N number of rows from a join tables. Some people may encounter unexpected performance problem. Here is an example SQL that retrieves first 1000 row from a join tables of Employee and Department in the order of dpt_id. Where emp_dept and dpt_id columns
- [How to Tune substr(emp_name,5,4) SQL Statement?](https://tosska.com/how-to-tune-substremp_name54-sql-statement/) - There may be some business requirements that need to compare certain part of a column as a data retrieval criteria. Here is an example SQL that retrieves data from EMPLOYEE table employee’s name with a string pattern “Acco” start from 5 character of the emp_name. select * from employee where substr(emp_name,5,4)='Acco' Here the following are the query
- [How to Tune “order by rand() limit 1” SQL Statement ?](https://tosska.com/how-to-tune-order-by-rand-limit-1-sql-statement/) - There may be some business requirements that needs to retrieve only some rows from a table (or join tables) randomly. This kind of SQL is normally hard to tune. For example the following SQL retrieve one row from two tables join of Employee and Department, where Employee’s department code is ‘AAA’, and both Emp_dept and
- [How to Tune SQL with COUNT(*) statements ?](https://tosska.com/how-to-tune-sql-with-count-statements/) - It is common that we used to count the number of records in a table. You may encounter unexpected performance degradation in certain situations. Here is an example SQL that count number of records from EMPLOYEE table. There are number of indexes are built such as emp_id, emp_dept, emp_grade, emp_hire_date and etc.... SELECT COUNT(*) FROM
- [How to Tune SQL with LIKE '%Mary%' comparison?](https://tosska.com/how-to-tune-sql-with-like-mary-comparison/) - The LIKE is a logical operator that determines if a character string matches a specified pattern. A pattern may include regular characters and wildcard characters. The LIKE operator is used in the WHERE clause of the SELECT, UPDATE, and DELETE statements to filter rows based on pattern matching. Here is an example SQL that retrieves
- [Tosska SQL Tuning Expert  (TSEM™) for MySQL 2.0.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tsem-for-mysql-2-0-0-release-notes/) - Click to view Tosska SQL Tuning Expert (TSEM™) for MySQL 2.0.0 Release Notes
- [Tosska SQL Tuning Expert Pro (TSE Pro™) 3.3.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-3-3-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 3.3.0 Release Notes
- [Tosska SQL Tuning Expert (TSE™) 3.2.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tse-3-2-0-release-notes/) - Click to view Tosska SQL Tuning Expert (TSE™) 3.2.0 Release Notes
- [Tosska Technologies announces the availability of Tosska SQL Tuning Expert (TSEM™) for MySQL® version 1.1.0](https://tosska.com/tosska-technologies-announces-the-availability-of-tosska-sql-tuning-expert-tsem-for-mysql-version-1-1-0/) - Probably the only AI-based machine SQL tuning product for the MySQL® database Apr. 10, 2020 Hong Kong, Apr. 10, 2020 - Tosska Technologies Limited (Tosska), an IT company that provides database and SQL performance related tools using Artificial Intelligent technology, today announces the general availability of Tosska SQL Tuning Expert (TSEM™) for MySQL® version 1.1.0,
- [Why I can only see the first 20 alternatives after tuning of my SQL?](https://tosska.com/can-see-first-30-alternatives-tuning-sql/) - Tosska SQL Tuning Expert product series provide the first 20 alternatives for free if you don’t have a license. If you are satisfied with our product’s functionality, you should purchase a license from our website to enjoy the full power of our product.
- [Tosska SQL Tuning Expert (TSEM™) for MySQL® - System Requirements](https://tosska.com/tosska-sql-tuning-expert-tsem-for-mysql-system-requirements/) - Before installing Tosska SQL Tuning Expert (TSEM™) for MySQL®, please make sure your system meets the following minimum hardware and software requirements: CPU 1.8 GHz Processor Memory 2 GB of RAM minimum, 4 GB of RAM recommended Hard Disk Space 200 MB of disk space for 32-bit installation 400 MB of disk space for
- [Tosska SQL Tuning Expert  (TSEM™) for MySQL 1.1.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tsem-for-mysql-1-1-0-release-notes/) - Click to view Tosska SQL Tuning Expert (TSEM™) for MySQL 1.1.0 Release Notes
- [How to get free trial from Tosska?](https://tosska.com/how-to-get-free-trial-from-tosska/) - Tosska understands that nothing is more convincing than doing a trial of the product in your own environment. Therefore Tosska provides trials of all Tosska products free of charge. All you need to do is to pick the product you want to do the trial, fill in your email address, make sure the email address
- [Want to download a free trial?](https://tosska.com/want-to-download-a-free-trial/) - Tosska understands that nothing is more convincing than doing a trial of the product in your own environment. Therefore Tosska provides trials of all Tosska products free of charge. Just select the product you want to do the trial, type in your email address (please make sure you put in the correct email address) and
- [How to buy products from Tosska?](https://tosska.com/how-to-buy-products-from-tosska/) - Welcome to the world of Tosska ! We are happy that you have decided to partner with us to let us help you with our Tosska solutions. Please select the product (and choose the options, if any) that you want and proceed to checkout. In the checkout page, please fill in the Order details. Please
- [Tosska SQL Tuning Expert (TSE™) 3.1.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tse-3-1-0-release-notes/) - Click to view Tosska SQL Tuning Expert (TSE™) 3.1.0 Release Notes
- [Tosska SQL Tuning Expert Pro (TSE Pro™) 3.2.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-3-2-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 3.2.0 Release Notes
- [Tosska SQL Tuning Expert Pro (TSE Pro™) 3.2.1 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-3-2-1-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 3.2.1 Release Notes
- [Tosska SQL Tuning Expert Pro (TSE Pro™) 2.0.8 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-2-0-8-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 2.0.8 Release Notes
- [Tosska SQL Tuning Expert Pro (TSE Pro™) 3.0.1 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-3-0-1-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 3.0.1 Release Notes
- [Tosska SQL Tuning Expert Pro (TSE Pro™) 3.1.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-3-1-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 3.1.0 Release Notes
- [Tosska SQL Tuning Expert (TSE™) 3.0.1 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tse-3-0-1-release-notes/) - Click to view Tosska SQL Tuning Expert (TSE™) 3.0.1 Release Notes
- [Tosska SQL Tuning Expert (TSE™) 2.0.3 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tse-2-0-3-release-notes/) - Click to view Tosska SQL Tuning Expert (TSE™) 2.0.3 Release Notes
- [Reveal the power of CBO](https://tosska.com/reveal-the-power-of-cbo/) - Example to Unveil the Power of Oracle Cost-Based SQL Optimizer A user who has a SQL statement takes a long time to execute, actually the SQL is not very complicated, but it has a very complex execution plan. Mimic SQL text ： SELECT TO_CHAR(SYSDATE, 'yyyy-mm-dd') AS STAT_DATE, SYSDATE AS STAT_TIME, X.TABLE_NAME, NVL(X.NUM_ROWS, 0) AS TABLE_ROWS,
- [What to do if getting "Submission rejected, token invalid" error when downloading](https://tosska.com/submission-rejected-token-invalid-error-when-downloading/) - Some users may encounter the error "Submission rejected, token invalid" when trying to download software from our website. If you have this problem, please try to clear the cached images and files of your browser and then retry again. See below: If you have done the above and still encounter the same error, then please
- [Tosska Technologies announces the availability of Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® version 2.0.8](https://tosska.com/tosska-technologies-announces-the-availability-of-tosska-sql-tuning-expert-pro-tse-pro-for-oracle-version-2-0-8/) - Bringing the automatic SQL tuning technology to new heights Dec. 20, 2018 Hong Kong, Dec. 20, 2018 - Tosska Technologies Limited (Tosska), an IT company that provides database and SQL performance related tools using Artificial Intelligent technology, today announces the general availability of Tosska SQL Tuning Expert Pro (TSE Pro™) version 2.0.8, an advanced version
- [What's new in Tosska SQL Tuning Expert Pro for Oracle Version 2 ?](https://tosska.com/whats-new-in-tosska-sql-tuning-expert-pro-for-oracle-version-2/) - Bring the automatic SQL tuning technology to new heights With almost doubled the number of hints supported in version 2, Tosska SQL Tuning Expert Pro (TSE Pro) V2 SQL tuning ability is brought to new heights. It creates a new standard of Hints-injection-based SQL tuning ability that no other tools can achieve in the market.
- [Can I use TSE™ to tune and test run DML statements?](https://tosska.com/can-use-tse-tune-test-run-dml-statements/) - Yes, you can tune DML statement such as Insert, Update and Delete statements. All update data will be rollback after test run process. So, your data integrity will be kept across the board.
- [Do I have to implement all indexes recommended by TSE Pro?](https://tosska.com/do-i-have-to-implement-all-indexes-recommended-by-tse-pro/) - You can evaluate the efficiency of the recommended indexes to your SQL workload to select most effective indexes for your database, but we recommend you to decrease the size of “Maximum number of recommended indexes” to let our AI engine to recommend a new set of indexes with less number of indexes.
- [What should I do if no better alternatives can be found for my SQL?](https://tosska.com/what-should-i-do-if-no-better-alternatives-can-be-found-for-my-sql/) - If you cannot find better alternatives at the current Intelligent Level, you can increase the Intelligent Level or disable the “Disregard SQL alternatives with cost > 50 times of Original SQL” to try more Hints permutation for your SQL statement.
- [What kind of SQL workload should I capture for index recommendation?](https://tosska.com/what-kind-of-sql-workload-should-i-capture-for-index-recommendation/) - You should capture the most representative SQL workload that created performance problem in your system. For example, if there was a performance problem at 11:00 AM yesterday, you should extract this SQL workload from AWR for index recommendation.
- [Do I use elapsed time or response time as my SELECT statement tuning objective?](https://tosska.com/do-i-use-elapsed-time-or-response-time-as-my-select-statement-tuning-objective/) - Best elapsed time as the tuning objective for SELECT statement is normally useful for most situations, but for some online screens for many records display, good response time is very important for user experience. So, you should consider using response time as the tuning objective for this kind of applications.
- [Can I use SQL Plan Baselines instead of SQL Patches?](https://tosska.com/can-i-use-sql-plan-baselines-instead-of-sql-patches/) - Yes, you can turn on SQL Plan Baselines in Deploy Plan page in Options window, but we recommend using SQL Patches without the SQL Plan Baselines’ hints application’s limitations.
- [Can I tune the SELECT portion only for an INSERT statement?](https://tosska.com/can-i-tune-the-select-portion-only-for-an-insert-statement/) - No, the SELECT portion’s execution plan may be different when it is executed with the INSERT operation. We recommend to tune whole INSERT statement without splitting it into pieces.
- [How does TSE Pro™ work and what technology does it use?](https://tosska.com/how-does-tse-pro-work-and-what-technology-does-it-use/) - Tosska SQL tuning uses our proprietary Auto-Hints-Injection technology to highly explore a given SQL statement’s potential execution plans that the Oracle SQL optimizer cannot archive within a limited timeframe. Furthermore, our technology is not limited by unreliable cost estimation algorithm, blinding SQL syntax restructure or any misleading human rule-of-thumb assumptions, since all those methods may
- [Tosska SQL Tuning Expert (TSE™) 1.5.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tse-1-5-0-release-notes/) - Click to view Tosska SQL Tuning Expert (TSE™) 1.5.0 Release Notes
- [Tosska Technologies announces the availability of Tosska SQL Tuning Expert (TSE™) for Oracle® version 1.5.0](https://tosska.com/tosska-technologies-announces-the-availability-of-tosska-sql-tuning-expert-tse-for-oracle-version-1-5-0/) - An innovative machine tuning tool for SQL statements further enhanced June. 23, 2018 Hong Kong, June 23, 2018 - Tosska Technologies Limited (Tosska), an IT company that provides database and SQL performance related tools, today announces the general availability of Tosska SQL Tuning Expert (TSE™) version 1.5.0, the enhanced version of their first "one-click machine
- [How TSE Pro™ helps save your effort to tune a SQL ?](https://tosska.com/how-tse-pro-helps-save-your-effort-to-tune-a-sql/) - There have been already a lot of SQL tuning products in the market providing better query plan visualization, better statistics analysis, high cost query plan steps indication, or even rule-of-thumb syntax recommendations. All in all, those tools are not helpful if users don’t have in-depth SQL tuning knowledge and are not willing to spend extra
- [How TSE Pro™ helps save your effort to implement the SQL performance fix](https://tosska.com/how-tse-pro-helps-save-your-effort-to-implement-the-sql-performance-fix/) - Developers are used to tuning SQL statements by rewriting or applying hints to the SQL text to influence database SQL optimizer to generate a better query plan for the SQL statement. A tuned SQL statement must be placed back to the program source and necessary testing has to be carried out before software deployment. It
- [How does TSE Pro™ different from TSE™ ?](https://tosska.com/how-does-tse-pro-different-from-tse/) - Below are the Products Features Comparison between Tosska SQL Tuning Expert Pro (TSE Pro™) and Tosska SQL Tuning Expert (TSE™) : Modules Tosska SQL Tuning Expert Pro (TSE Pro™) Tosska SQL Tuning Expert (TSE™) Tune SQL – Hints Injection Yes Yes Tune SQL – Deploy Plan Yes No Advise Indexes Yes No Manage SQL
- [Tosska Technologies announces the availability of their major SQL performance tuning product - Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle®](https://tosska.com/tosska-technologies-announces-the-availability-of-their-major-sql-performance-tuning-product-tosska-sql-tuning-expert-pro-tse-pro-for-oracle/) - Intelligent SQL tuning without touching your source code May. 15, 2018 Hong Kong, May 15, 2018 - Tosska Technologies Limited (Tosska), an IT company that provides database and SQL performance related tools, today announces the general availability of Tosska SQL Tuning Expert Pro (TSE Pro™), the major product of the Tosska SQL Tuning Expert Family
- [Tosska Technologies announces the availability of their flagship SQL performance tuning product - Tosska SQL Tuning Expert (TSE™) for Oracle®](https://tosska.com/tosska-technologies-announces-availability-flagship-sql-performance-tuning-product-tosska-sql-tuning-expert-tse-oracle/) - An innovative machine tuning tool for SQL statements Dec. 18, 2017 Hong Kong, December 18, 2017 - Tosska Technologies Limited (Tosska), an IT company that provides database and SQL performance related tools, today announces the general availability of Tosska SQL Tuning Expert (TSE™), their first product that provide machine tuning capability to improve SQL performance
- [Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® Trial Version Limitations](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-for-oracle-trial-version-limitations/) - Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® Trial Version has the following Limitations: The TSE Pro™ trial version provides only up to 30 automatic SQL alternatives to solve most common SQL performance problems. The TSE Pro™ trial version advises indexes based on SQL workload for at most 100 SQLs only. If you want
- [TIM™ 1.2.0 Release Notes](https://tosska.com/tim-1-2-0-release-notes/) - Click to view TIM™ 1.2.0 Release Notes
- [Tosska SQL Tuning Expert (TSE™) 1.1.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tse-1-1-0-release-notes/) - Click to view Tosska SQL Tuning Expert (TSE™) 1.1.0 Release Notes
- [Tosska SQL Tuning Expert (TSE™) 1.1.1 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tse-1-1-1-release-notes/) - Click to view Tosska SQL Tuning Expert (TSE™) 1.1.1 Release Notes
- [Tosska SQL Tuning Expert (TSE™) 1.1.2 Release Notes](https://tosska.com/tosska-sql-tuning-expert-tse-1-1-2-release-notes/) - Click to view Tosska SQL Tuning Expert (TSE™) 1.1.2 Release Notes
- [Tosska SQL Tuning Expert Pro (TSE Pro™) 1.1.0 Release Notes](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-1-1-0-release-notes/) - Click to view Tosska SQL Tuning Expert Pro (TSE Pro™) 1.1.0 Release Notes
- [Unlock the power of using Oracle Optimizer Hints to tune SQL statements](https://tosska.com/unlock-power-using-oracle-optimizer-hints-tune-sql-statements/) - Common SQL tuning methods SQL tuning is the process to improve a SQL statement’s performance up to the user’s expectation. There are at least three methods which are commonly used by developers or DBAs, These methods are creating new indexes, rewriting the SQL syntax and applying Oracle Optimizer Hints to the SQL statements. Each method
- [Tosska SQL Tuning Expert (TSE™) for Oracle® Free Download Limitations](https://tosska.com/tse-free-download-limitations/) - Tosska SQL Tuning Expert (TSE™) for Oracle® Free Download version has the following Limitations: If you use TSE™ without a license, the software provides only up to 30 automatic SQL alternatives to solve most common SQL performance problems. TSE™ however will still let you know if there are better solutions beyond the 30 alternatives if
- [There are some SQL alternatives generated by TSE™ with row count mismatched error during test run?](https://tosska.com/sql-alternatives-generated-tse-row-count-mismatched-error-test-run/) - Yes, it is possible that some SQL alternatives generated by TSE™ may have row count mismatched error. The problem is caused by wrong execution plan generated by Oracle SQL optimizer for the Hints that specified by TSE™. These SQL alternatives are not counted as best alternatives in TSE™, user should not use this kind of
- [Tosska SQL Tuning Expert (TSE™) for Oracle® - System Requirements](https://tosska.com/tosska-sql-tuning-expert-tse-oracle-system-requirements/) - Before installing Tosska SQL Tuning Expert (TSE™) for Oracle®, please make sure your system meets the following minimum hardware and software requirements: CPU 1.8 GHz Processor Memory 2 GB of RAM minimum, 4 GB of RAM recommended Hard Disk Space 200 MB of disk space for 32-bit installation 400 MB of disk space for
- [How can I speed up the tuning process for long runtime SQL?](https://tosska.com/can-speed-tuning-process-long-runtime-sql/) - Yes, if you have an expected runtime of your SQL statement, you can use it as the termination time to kill each SQL alternative by setting the “User define time” in “Termination Criteria” in “Test Run All Options”.
- [How many times should I test run each SQL alternative?](https://tosska.com/many-times-test-run-sql-alternative/) - If your SQL’s runtime is short such as less than 10 seconds, the time of data cache from hard disc to memory and SQL parsing time may be significant to the total runtime. So, execute every SQL alternative for 2 times and use the second runtime to compare with each other. For very short time
- [I cannot find a better SQL in the current SQL alternatives, what should I do?](https://tosska.com/cannot-find-better-sql-current-sql-alternatives/) - If you cannot find a SQL with satisfied performance in current SQL alternatives, you can increase the Intelligent Level to a higher degree in Options window to investigate more SQL alternatives. The higher degree of Intelligent Level, the more chance you get a better SQL alternative.
- [Can I replace the variables of a SQL with literals for SQL tuning?](https://tosska.com/can-replace-variables-sql-literals-sql-tuning/) - No, due to the Oracle SQL optimizer will treat variables and hardcoded literals in different ways. For example; Select * from TableA where A.key
- [Do I have to tune the SQL statement again to get the best SQL alternative’s text after I have purchased a license?](https://tosska.com/tune-sql-statement-get-best-sql-alternatives-text-purchased-license/) - No, the best SQL alternative text will be displayed immediately after you input a valid license into TSE™.
- [Do I have to install Oracle Client to connect a database?](https://tosska.com/install-oracle-client-connect-database/) - No, you can use “Basic Type” option in the Connection Mode when you are creating a connection in Connection Manager. Only Host name/IP, port id and SID/Service name are required for “Basic Type” option. Oracle client is required only if you are using “TNS” option as the Connection Mode.
- [Why use Oracle In-Memory database from another perspective](https://tosska.com/use-oracle-memory-database-another-perspective/) - A lot of people are talking about why or why not use Oracle In-memory database in their applications and most of them are too focused on the size of the database or whether it is an OLAP application. It seems that small and medium size databases are not suitable for using Oracle In-memory database option.
- [TIM™ - Full Description](https://tosska.com/tim-full-description/) - About Tosska In-memory Maestro (TIM™) for Oracle® Tosska In-memory Maestro (TIM™) for Oracle® automates the In-memory SQL optimization process and provide In-memory objects recommendations for a given SQL workload with our proprietary artificial intelligent engine. It also provides user friendly In-memory simulation function for user to virtually evaluate their in-memory table objects for one SQL
- [How to submit a support request / bug report?](https://tosska.com/how-to-submit-a-support-request-bug-report/) - You are welcome to submit your support requests / bug reports to us by sending emails to support@tosska.com or by filling in the Support Request Form. However, before submitting such request, we recommend you to do the followings : Make sure to first read the FAQ page and the documentations included with the product. Make sure

## Pages

- [About Us](https://tosska.com/) - The ever changing database management challenges With the rapid changes of modern databases, database administrators and developers have to learn and manage new features provided by databases with short period of time. There is always a time gap between fully mastering new features and actually implementing the new features in production. Easy-to-use AI enabled tools
- [Product Updates - MySQL® Products](https://tosska.com/product-updates-mysql-products/) - Welcome !
- [Product Updates - Oracle® Products](https://tosska.com/product-updates-oracle-products/) - Welcome ! * Please note that TSE is no more available and is replaced by the more powerful product TSE Pro.
- [Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® v5.0.0 - Free Upgrade](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-for-oracle-v5-0-0-free-upgrade/)
- [Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® v4.8.2 - Free Upgrade](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-for-oracle-v4-8-2-free-upgrade/)
- [Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® - Buy License](https://tosska.com/tosska-sql-tuning-expert-pro-tsep-for-oracle-buy-license/)
- [Documentations - Oracle® Products](https://tosska.com/documentation/documentations-oracle-products/) - Tosska DB Ace Enterprise (DBAO™) for Oracle® Tosska DB Ace Enterprise (DBAO™) for Oracle® Installation guide Tosska DB Ace Enterprise (DBAO™) for Oracle® 4.0.0 Release Notes Tosska DB Ace Enterprise (DBAO™) for Oracle® 3.2.0 Release Notes Tosska DB Ace Enterprise (DBAO™) for Oracle® 3.1.0 Release Notes Tosska DB Ace Enterprise (DBAO™) for Oracle® 3.0.0 Release
- [Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss® v1.8.1 - Free Upgrade](https://tosska.com/tosska-sql-tuning-expert-pro-tseg-pro-for-opengauss-v1-8-1-free-upgrade/)
- [Product Updates - openGauss® Products](https://tosska.com/product-updates-opengauss-products/) - Welcome !
- [Documentations - openGauss® Products](https://tosska.com/documentations-opengauss-products/) - Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss® Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss® Installation guide Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss® 1.8.1 Release Notes Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss® 1.6.0 Release Notes Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss® 1.5.0 Release
- [Tosska DB Ace Enterprise (DBAM™) for MySQL® v2.0.4 - Free Upgrade](https://tosska.com/tosska-db-ace-enterprise-dbam-for-mysql-v2-0-4-free-upgrade/)
- [Tosska DB Ace Enterprise (DBAM™) for MySQL® v3.0.0 - Free Upgrade](https://tosska.com/tosska-db-ace-enterprise-dbam-for-mysql-v3-0-0-free-upgrade/)
- [Tosska DB Ace Enterprise (DBAM™) for MySQL® - Buy License](https://tosska.com/tosska-db-ace-enterprise-dbam-for-mysql-buy-license/) - We only offer Bronze Level licensing for online purchase. For other licensing options, such as Silver or Gold License Levels or Enterprise / Global licenses, please contact us directly at https://tosska.com/contact-us and our sales agent will contact you shortly.
- [Documentations - MySQL® Products](https://tosska.com/documentation/documentations-mysql-products/) - Tosska DB Ace Enterprise (DBAM™) for MySQL® Tosska DB Ace Enterprise (DBAM™) for MySQL® Installation guide Tosska DB Ace Enterprise (DBAM™) for MySQL® 3.0.0 Release Notes Tosska DB Ace Enterprise (DBAM™) for MySQL® 2.0.0 Release Notes
- [Tosska DB Ace Enterprise (DBAO™) for Oracle® v3.2.2 - Free Upgrade](https://tosska.com/tosska-db-ace-enterprise-dbao-for-oracle-v3-2-2-free-upgrade/)
- [Tosska DB Ace Enterprise (DBAO™) for Oracle® v4.0.0 - Free Upgrade](https://tosska.com/tosska-db-ace-enterprise-dbao-for-oracle-v4-0-0-free-upgrade/)
- [Tosska DB Ace Enterprise (DBAO™) for Oracle® - Buy License](https://tosska.com/tosska-db-ace-enterprise-dbao-for-oracle-buy-license/) - We only offer Bronze Level licensing for online purchase. For other licensing options, such as Silver or Gold License Levels or Enterprise / Global licenses, please contact us directly at https://tosska.com/contact-us and our sales agent will contact you shortly.
- [Product Updates - PostgreSQL® Products](https://tosska.com/product-updates-postgresql-products/) - Welcome !
- [Tosska DB Ace Enterprise (DBAP™) for PostgreSQL® v1.1.0 - Free Upgrade](https://tosska.com/tosska-db-ace-enterprise-dbap-for-postgresql-v1-1-0-free-upgrade/)
- [Documentations - PostgreSQL® Products](https://tosska.com/documentations-postgresql-products/) - Tosska DB Ace Enterprise (DBAP™) for PostgreSQL® Tosska DB Ace Enterprise (DBAP™) for PostgreSQL® Installation guide Tosska DB Ace Enterprise (DBAP™) for PostgreSQL® 1.1.0 Release Notes Tosska DB Ace Enterprise (DBAP™) for PostgreSQL® 1.0.5 Release Notes
- [Tosska DB Ace Enterprise (DBAP™) for PostgreSQL® - Download Free Trial](https://tosska.com/tosska-db-ace-enterprise-for-postgresql-download-free-trial/) - If you also use Oracle® database, you may also want to try our other product, Tosska DB Ace Enterprise (DBAO™) for Oracle®, which provides automated one-button-SQL statements tuning as well as many robust SQL management features for the Oracle® database. Click here for details.
- [Our Products](https://tosska.com/our-product/) - The Tosska DB Ace Enterprise Products Family Predicting, finding, and solving the problem with the right tool Traditional monitor and SQL analysis tools in the market are focused on locating the high resource consumption SQL or screening SQL with basic SQL syntax and query plan analysis. Tosska DB Ace Enterprise is an innovative tool that
- [Tosska DB Ace Enterprise for PostgreSQL](https://tosska.com/tosska-db-ace-enterprise-for-postgresql/) - Tired of slow reports, sluggish applications, and the endless guesswork of SQL tuning? Tosska DB Ace Enterprise is your dedicated performance engineer. It automatically finds the fastest path for your PostgreSQL queries, saving you hours of manual work and delivering results that manual tuning often misses. Get ready to unlock hidden performance, accelerate development, and
- [Tosska DB Ace Enterprise (DBAP™) for PostgreSQL® - Buy License](https://tosska.com/tosska-db-ace-enterprise-dbap-for-postgresql-buy-license/) - We only offer Bronze Level licensing for online purchase. For other licensing options, such as Silver or Gold License Levels or Enterprise / Global licenses, please contact us directly at https://tosska.com/contact-us and our sales agent will contact you shortly.
- [Tosska DB Ace Enterprise (DBAP™) for PostgreSQL® - Annual Maintenance Renewal](https://tosska.com/tosska-db-ace-enterprise-dbap-for-postgresql-maintenance-renewal/) - Annual Maintenance Renewal is only available for customers that are actively on maintenance, or within maintenance renewal grace period (within 30 days after maintenance expires). Please contact us directly at https://tosska.com/contact-us if otherwise. Our sales agent will contact you shortly.
- [Explore the full power of DB Ace Enterprise for PostgreSQL](https://tosska.com/message-db-ace-enterprise-for-postgresql/) - Thanks for using Tosska products and I hope you have enjoyed your trial. I am sure you would be amazed by what Tosska DB Ace Enterprise for PostgreSQL can do for you … it has all the tools a DBA needs to manage SQLs in the enterprise as well as the powerful yet easy to
- [Product Updates - SQL Server® Products](https://tosska.com/product-updates-sql-server-products/) - Welcome ! * Please note that Tosska SQL Tuning Expert for SQL Server Pro (TSES Pro™) is now replaced by the more powerful product Tosska DB Ace Enterprise (DBAS™) for SQL Server
- [Tosska DB Ace Enterprise (DBAS™) for SQL Server® v2.1.3 - Free Upgrade](https://tosska.com/tosska-db-ace-enterprise-dbas-for-sql-server-v2-1-3-free-upgrade/)
- [Tosska SQL Tuning Expert Pro (TSEP Pro™) for PostgreSQL® v1.1.0 - Free Upgrade](https://tosska.com/tosska-sql-tuning-expert-pro-tsep-pro-for-postgresql-v1-1-0-free-upgrade/)
- [Tosska SQL Tuning Expert Pro (TSEP Pro™) for PostgreSQL® - Buy License](https://tosska.com/tosska-sql-tuning-expert-pro-tsep-for-postgresql-buy-license/)
- [Tosska SQL Tuning Expert Pro (TSEP Pro™) for PostgreSQL® - Annual Maintenance Renewal](https://tosska.com/tosska-sql-tuning-expert-pro-tsep-pro-for-postgresql-annual-maintenance-renewal/) - Annual Maintenance Renewal is only available for customers that are actively on maintenance, or within maintenance renewal grace period (within 30 days after maintenance expires). Please contact us directly at https://tosska.com/contact-us if otherwise. Our sales agent will contact you shortly.
- [Tosska SQL Tuning Expert Pro (TSEP Pro™) for PostgreSQL® - Free Download](https://tosska.com/tosska-sql-tuning-expert-pro-tsep-for-postgresql-download-free-trial/)
- [Tosska SQL Tuning Expert Pro for PostgreSQL](https://tosska.com/tosska-sql-tuning-expert-pro-tsep-pro-for-postgresql/) - Struggling with PostgreSQL’s query Planner/Optimizer limitations or tangled SQL code? The Tosska SQL Tuning Expert Pro empowers teams to optimize SQL performance with surgical precision, combining four powerhouse technologies: PG_HINT_PLAN, HypoPG, Automatic SQL Rewrite, and Advanced GUC Parameter Tuning. Designed for DBAs and developers, Tosska automates complex tuning tasks, turning hours of manual work into
- [Explore the full power of TSE Pro for PostgreSQL](https://tosska.com/message-tse-pro-postgresql/) - Thanks for using Tosska products and I am sure you would be amazed by what TSE Pro for PostgreSQL can do for you. But do you know you can do a lot more with TSE Pro for PostgreSQL ? Explore the full power of TSE Pro for PostgreSQL with unlimited Intelligent Level, more thorough automatic
- [Tosska SQL Tuning Expert Pro (TSEG Pro™) for OpenGauss®](https://tosska.com/tosska-sql-tuning-expert-pro-tseg-pro-for-opengauss/) - Why SQL tuning? SQL tuning is the process of optimizing SQL statements to achieve the best possible performance. It involves finding the most efficient way to execute a query, similar to finding the fastest route from work to home among various options. To tune SQL statements effectively, you need to understand your database architecture and
- [Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss® - Free Download](https://tosska.com/tosska-sql-tuning-expert-pro-tseg-for-opengauss-download-free-trial/)
- [Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss® - Buy License](https://tosska.com/tosska-sql-tuning-expert-pro-tseg-for-opengauss-buy-license/)
- [Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss® - Annual Maintenance Renewal](https://tosska.com/tosska-sql-tuning-expert-pro-tseg-pro-for-opengauss-annual-maintenance-renewal/) - Annual Maintenance Renewal is only available for customers that are actively on maintenance, or within maintenance renewal grace period (within 30 days after maintenance expires). Please contact us directly at https://tosska.com/contact-us if otherwise. Our sales agent will contact you shortly.
- [Explore the full power of TSE Pro for Opengauss](https://tosska.com/message-tse-pro-opengauss/) - Thanks for using Tosska products and I am sure you would be amazed by what TSE Pro for openGauss can do for you. But do you know you can do a lot more with TSE Pro for openGauss ? Explore the full power of TSE Pro for openGauss with unlimited Intelligent Level, more thorough SQL
- [Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle®](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-for-oracle/) - It is not another SQL Tuning tool There have been already a lot of SQL tuning products in the market providing better query plan visualization, better statistics analysis, high cost query plan steps indication or even rule-of-thumb syntax recommendations. All in all, those tools are not helpful if users don’t have in-depth SQL tuning knowledge
- [Tosska SQL Tuning Expert (TSE™) for Oracle® - Free Download](https://tosska.com/tosska-sql-tuning-expert-tse-oracle-free-download/)
- [Tosska SQL Tuning Expert (TSE™) for Oracle® - Buy License](https://tosska.com/tosska-sql-tuning-expert-tse-for-oracle-buy-license/)
- [Tosska SQL Tuning Expert (TSE™) for Oracle®](https://tosska.com/tosska-sql-tuning-expert-tse-oracle/)
- [Tosska SQL Tuning Expert for MySQL (5.1-5.5)® (TSEM5™) - Free Download](https://tosska.com/tosska-sql-tuning-expert-for-mysql-5-1-5-5-tsem5-free-download/)
- [Tosska SQL Tuning Expert for MySQL® (TSEM™)- Buy License](https://tosska.com/tosska-sql-tuning-expert-tse-for-mysql-buy-license/)
- [Tosska SQL Tuning Expert for MySQL <small>(5.1-5.5)</small>® (TSEM5™) - Buy License](https://tosska.com/tosska-sql-tuning-expert-tse-for-mysql5-buy-license/)
- [Tosska SQL Tuning Expert for MySQL® (TSEM™) - Free Download](https://tosska.com/tosska-sql-tuning-expert-for-mysql-tsem-free-download/)
- [Tosska DB Ace Enterprise for SQL Server](https://tosska.com/tosska-db-ace-enterprise-for-sql-server/) - What is Tosska DB Ace for SQL Server? Tosska DB Ace is a complete SQL tuning solution that provides the world’s leading automatic SQL syntax rewrite, Query Hints injection, Plan Guide SQL tuning, Query Store SQL tuning, and index recommendation to maximize the performance of a SQL statement for MS SQL Server. World’s Leading A.I.
- [Tosska DB Ace Enterprise for MySQL](https://tosska.com/tosska-db-ace-enterprise-for-mysql/) - Finding and solving the problem with the right tool Tosska DB Ace Enterprise is an innovative and groundbreaking tool designed for MySQL, offering comprehensive insights into your database performance. It allows you to monitor the individual SQL execution behavior while providing a broader view of your overall database performance. Equipped with powerful A.I.-powered SQL tuning
- [Tosska SQL Tuning Expert (TSES™) for SQL Server®](https://tosska.com/tosska-sql-tuning-expert-tses-for-sql-server/) - Powerful Cold Cache SQL Tuning for Infrequent Executed SQL Statements For SQL statements that are not executed frequently, so that the relevant data is no longer exists in the buffer cache, a cold cache will significantly affect the performance of a SQL statement. A good performance SQL for hot cache may not be performing well
- [Tosska SQL Tuning Expert (TSEM™) for MySQL®](https://tosska.com/tosska-sql-tuning-expert-tse-for-mysql-2/)
- [Tosska DB Ace Enterprise (DBAM™) for MySQL® - Download Free Trial](https://tosska.com/tosska-db-ace-enterprise-for-mysql-download-free-trial/) - If you also use Oracle® database, you may also want to try our other product, DB Ace Enterprise (DBAO™) for Oracle®, which provides automated one-button-SQL statements tuning for the Oracle® database. Click here for details.
- [Tosska DB Ace Enterprise (DBAM™) for MySQL® - Annual Maintenance Renewal](https://tosska.com/tosska-db-ace-enterprise-dbam-for-mysql-annual-maintenance-renewal/) - Annual Maintenance Renewal is only available for customers that are actively on maintenance, or within maintenance renewal grace period (within 30 days after maintenance expires). Please contact us directly at https://tosska.com/contact-us if otherwise. Our sales agent will contact you shortly.
- [Tosska DB Ace Enterprise for Oracle](https://tosska.com/tosska-db-ace-enterprise-for-oracle/) - Predicting, finding, and solving the problem with the right tool Traditional monitor and SQL analysis tools in the market are focused on locating the high resource consumption SQL or screening SQL with basic SQL syntax and query plan analysis. Tosska DB Ace Enterprise is an innovative tool that not only shows you from the individual
- [Explore the full power of DB Ace Enterprise for MySQL](https://tosska.com/explore-the-full-power-of-db-ace-enterprise-for-mysql/) - Thanks for using Tosska products and I hope you have enjoyed your trial. I am sure you would be amazed by what Tosska DB Ace Enterprise for MySQL can do for you ... it has all the tools a DBA needs to manage SQLs in the enterprise as well as the powerful yet easy to
- [Documentations - SQL Server® Products](https://tosska.com/documentation/documentations-sql-server-products/) - Tosska DB Ace Enterprise (DBAS™) for SQL Server® Tosska DB Ace Enterprise (DBAS™) for SQL Server® Installation guide Tosska DB Ace Enterprise (DBAS™) for SQL Server® 2.1.1 Release Notes Tosska DB Ace Enterprise (DBAS™) for SQL Server® 2.1.0 Release Notes Tosska DB Ace Enterprise (DBAS™) for SQL Server® 2.0.0 Release Notes
- [Tosska SQL Tuning Expert Pro for SQL Server® (TSES Pro™)- Buy License](https://tosska.com/tosska-sql-tuning-expert-pro-tsep-for-sql-server-buy-license/)
- [Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server® - Download Free Trial](https://tosska.com/tosska-sql-tuning-expert-pro-tses-pro-for-sql-server-download-free-trial/)
- [Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server®](https://tosska.com/tosska-sql-tuning-expert-pro-tses-pro-for-sql-server/)
- [Tosska SQL Tuning Expert for SQL Server® (TSES™)- Buy License](https://tosska.com/tosska-sql-tuning-expert-tse-for-sql-server-buy-license/)
- [Tosska SQL Tuning Expert for SQL Server® (TSES™) - Free Download](https://tosska.com/tosska-sql-tuning-expert-for-sql-server-tses-free-download/)
- [Tosska SQL Tuning Expert (TSE Pro™) for Oracle® - Annual Maintenance Renewal](https://tosska.com/tosska-sql-tuning-expert-tse-pro-for-oracle-maintenance-renewal/) - Annual Maintenance Renewal is only available for customers that are actively on maintenance, or within maintenance renewal grace period (within 30 days after maintenance expires). Please contact us directly at https://tosska.com/contact-us if otherwise. Our sales agent will contact you shortly.
- [Tosska DB Ace Enterprise (DBAS™) for SQL Server® - Annual Maintenance Renewal](https://tosska.com/tosska-db-ace-enterprise-dbas-for-sql-server-maintenance-renewal/) - Annual Maintenance Renewal is only available for customers that are actively on maintenance, or within maintenance renewal grace period (within 30 days after maintenance expires). Please contact us directly at https://tosska.com/contact-us if otherwise. Our sales agent will contact you shortly.
- [Tosska DB Ace Enterprise (DBAS™) for SQL Server® - Buy License](https://tosska.com/tosska-db-ace-enterprise-dbas-for-sql-server-buy-license/) - We only offer Bronze Level licensing for online purchase. For other licensing options, such as Silver or Gold License Levels or Enterprise / Global licenses, please contact us directly at https://tosska.com/contact-us and our sales agent will contact you shortly.
- [Tosska DB Ace Enterprise (DBAS™) for SQL Server® - Download Free Trial](https://tosska.com/tosska-db-ace-enterprise-for-sql-server-download-free-trial/) - If you also use MySQL® database, you may want to try our other product, Tosska SQL Tuning Expert (TSEM™) for MySQL®, which provides automated one-button-SQL statements tuning for the MySQL® database. Click here for details.
- [Documentations - DB Ace Enterprise for SQL Server® Products](https://tosska.com/documentations-db-ace-enterprise-for-sql-server-products/) - Tosska DB Ace Enterprise (DBAS™) for SQL Server® Tosska DB Ace Enterprise (DBAS™) for SQL Server® Installation guide Tosska DB Ace Enterprise (DBAS™) for SQL Server® 2.1.0 Release Notes Tosska DB Ace Enterprise (DBAS™) for SQL Server® 2.0.0 Release Notes
- [Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® - Download Free Trial](https://tosska.com/tosska-sql-tuning-expert-pro-tse-pro-for-oracle-download-free-trial/) - If you also use MySQL® database, you may also want to try our other product, Tosska SQL Tuning Expert (TSEM™) for MySQL®, which provides automated one-button-SQL statements tuning for the MySQL® database. Click here for details. If you are using Oracle® In-memory option, you may also want to try our other product, Tosska
- [Documentations - DB Ace Enterprise for Oracle® Products](https://tosska.com/documentations-db-ace-for-oracle-products/) - Tosska DB Ace Enterprise (DBAO™) for Oracle® Tosska DB Ace Enterprise (DBAO™) for Oracle® Installation guide Tosska DB Ace Enterprise (DBAO™) for Oracle® 3.1.0 Release Notes Tosska DB Ace Enterprise (DBAO™) for Oracle® 3.0.0 Release Notes Tosska DB Ace Enterprise (DBAO™) for Oracle® 2.2.0 Release Notes Tosska DB Ace Enterprise (DBAO™) for Oracle® 2.1.1 Release
- [Tosska DB Ace Enterprise (DBAO™) for Oracle® - Annual Maintenance Renewal](https://tosska.com/tosska-db-ace-enterprise-dbao-for-oracle-maintenance-renewal/) - Annual Maintenance Renewal is only available for customers that are actively on maintenance, or within maintenance renewal grace period (within 30 days after maintenance expires). Please contact us directly at https://tosska.com/contact-us if otherwise. Our sales agent will contact you shortly.
- [Explore the full power of DB Ace Enterprise for SQL Server](https://tosska.com/message-db-ace-enterprise-for-sql-server/) - Thanks for using Tosska products and I hope you have enjoyed your trial. I am sure you would be amazed by what Tosska DB Ace Enterprise for SQL Server can do for you ... it has all the tools a DBA needs to manage SQLs in the enterprise as well as the powerful yet easy
- [Tosska DB Ace Enterprise (DBAO™) for Oracle® - Download Free Trial](https://tosska.com/tosska-db-ace-enterprise-for-oracle-download-free-trial/) - If you also use MySQL® database, you may also want to try our other product, Tosska SQL Tuning Expert (TSEM™) for MySQL®, which provides automated one-button-SQL statements tuning for the MySQL® database. Click here for details.
- [Explore the full power of DB Ace Enterprise for Oracle](https://tosska.com/message-db-ace-enterprise-for-oracle/) - Thanks for using Tosska products and I hope you have enjoyed your trial. I am sure you would be amazed by what Tosska DB Ace Enterprise for Oracle can do for you ... it has all the tools a DBA needs to manage SQLs in the enterprise as well as the powerful yet easy to
- [Explore the full power of TSE Pro for SQL Server !](https://tosska.com/message-tse-pro-sql-server/) - Thanks for using Tosska products and I hope you have enjoyed your trial. I am sure you would be amazed by what TSE Pro for SQL Server can achieve for you…solving your tedious SQL tuning problems with your SQL Server database with just simple point-and-clicks ! But do you know you can do a lot
- [Explore the full power of TSE for SQL Server !](https://tosska.com/message-tse-sql-server/) - Thanks for using Tosska products and I hope you have enjoyed your trial. I am sure you would be amazed by what TSE for SQL Server can achieve for you…solving your tedious SQL tuning problems with your SQL Server database with just simple point-and-clicks ! I would like to invite you to explore the full
- [Explore the full power of TSE !](https://tosska.com/message-tse/) - Thanks for using Tosska products and I hope you have enjoyed your trial. I am sure you would be amazed by what TSE can achieve for you...solving your tedious SQL tuning problems with just simple point-and-clicks ! I would like to invite you to explore the full power of TSE with unlimited Intelligent Level, more
- [Explore the full power of TSE Pro !](https://tosska.com/message-tse-pro/) - Thanks for using Tosska products and I am sure you would be amazed by what TSE Pro can do for you. But do you know you can do a lot more with TSE Pro ? Explore the full power of TSE Pro with unlimited Intelligent Level, more thorough SQL alternatives, more database connections and more
- [Blogs](https://tosska.com/blogs/)
- [Product Updates](https://tosska.com/product-update/) - Welcome !
- [Frequently Asked Questions](https://tosska.com/frequently-asked-questions/) - General Tosska SQL Tuning Expert (TSEM™) for MySQL® Tosska SQL Tuning Expert (TSE™) for Oracle® Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® Tosska In-Memory Maestro (TIM™) for Oracle®
- [Explore the full power of TSE for MySQL !](https://tosska.com/message-tse-mysql/) - Thanks for using Tosska products and I hope you have enjoyed your trial. I am sure you would be amazed by what TSE for MySQL can achieve for you...solving your tedious SQL tuning problems with your MySQL database with just simple point-and-clicks ! I would like to invite you to explore the full power of
- [Documentations](https://tosska.com/documentation/) - Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server® Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server® Installation guide Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server® 2.0.0 Release Notes Tosska SQL Tuning Expert (TSES™) for SQL Server® Tosska SQL Tuning Expert (TSES™) for SQL Server® Installation guide Tosska SQL
- [Tosska SQL Tuning Expert (TSE™) for Oracle® v3.2.0 - Free Download](https://tosska.com/tosska-sql-tuning-expert-tse-for-oracle-v3-2-0-free-download/)
- [Documentations - TSE™ 2.0.3 Release Note](https://tosska.com/documentations-tse-203-release-note/) - [pdf-embedder url="https://tosska.com/wp-content/uploads/2019/05/TSE-2.0.3-Release-Notes.pdf" title="TSE 2.0.3 Release Notes"]
- [The ultimate SQL tuning tool is here !](https://tosska.com/the-ultimate-sql-tuning-tool-is-here/) - TSE Pro Features and Benefits TSE Pro SQL tuning approachView Details | Get Free Trial | Buy License Simple Tuning Process Paste the problematic SQL statements and press button. The AI based Automatic Hints Injection process will be executed to look for potential better query plans. The best query plan will be shown on
- [Our Company](https://tosska.com/our-company/) - Our mission is to help users to smooth out the hurdle by our new technologies. Furthermore, Tosska is one of the very few companies in the world that focuses on using artificial intelligence technology to solve various database performance problems. It is our goal to help our customers to reduce their hardware investment; increase their
- [News](https://tosska.com/news/)
- [Tosska In-memory Maestro (TIM™) for Oracle® - Download Free Trial](https://tosska.com/tosska-in-memory-maestro-tim-for-oracle-download-free-trial/) - Want to find a tool to solve your SQL Tuning needs? Try Tosska SQL Tuning Expert (TSE™) for Oracle®, an innovative machine tuning tool for SQL statements. Click here for details. We also suggest you to try the professional version, Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle®, that can tune your SQL
- [Tips & Tricks](https://tosska.com/tips-tricks/) - Tosska SQL Tuning Expert (TSE™) for Oracle® Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® Tosska In-Memory Maestro (TIM™) for Oracle®
- [Our Services](https://tosska.com/our-service/) - Tosska Maestros' Club (TMC™) TMC™ Membership (Maintenance Plan) Product Update Support Frequently Asked Questions (FAQ) Submit Support Request Resources Documentations Tips & Tricks
- [TIM™ In-memory SQL Tuning](https://tosska.com/tim-in-memory-sql-tuning/) - For mission critical SQL statements, users may want to tune their SQL with Oracle® In-memory feature to the best performance. TIM™ provides an innovative function to help user to evaluate and tune a SQL with relevant table objects hypothetically populating into in-memory or depopulating from in-memory. An intelligent engine is embedded to thoroughly explore most
- [TIM™ In-memory Simulator](https://tosska.com/tim-in-memory-simulator/) - The IM Simulator is used to simulate how a number of virtually selected in-memory table objects that impacts a SQL workload captured from SGA or AWR. User can use the module to improve database performance for specific hours of a day; for example if user want to improve the peak hours performance of a day,
- [Tosska In-Memory Maestro (TIM™) for Oracle®](https://tosska.com/tosska-in-memory-maestro-tim-for-oracle/) - Tosska In-memory Maestro (TIM™) also provides user friendly In-memory simulation function for user to virtually evaluate their in-memory table objects for one SQL or a given SQL workload captured from SGA or AWR without actually populating those table objects. Tosska In-memory Maestro (TIM™) consists of the following modules: IM SQL Tuning Optimize SQL statement within
- [TIM™ In-memory Advisor](https://tosska.com/tim-in-memory-advisor/) - Due to the in-memory size limitation, user must be very careful to select what tables to populate into in-memory and work best for a given SQL Workload. A SQL workload is a set of SQL statements captured from Oracle AWR or SGA at a specific time, there may be up to thousands of SQL statements
- [TMC™ Membership (Maintenance)](https://tosska.com/maintenance-plan/) - Tosska Maestros’ Club (TMC™) Tosska’s current licensing policy allow all customers to enjoy lifetime FREE Release Upgrades (i.e. same product with the same version no. but of different releases) for the same product version as long as that product version is under 'active support'. However if customers want to enjoy the new functions and features
- [No return and no refund policy](https://tosska.com/no-return-and-no-refund-policy/) - No return and no refund policy Unless otherwise specified, all products are NOT refundable after purchase. Refunds will NOT be provided for any subscription. We will NOT provide credit, refunds, or prorated billing for any subscriptions to the Tosska Maestros' club membership (aka Tosska's software maintenance service) that are cancelled mid-year. In such circumstance, you
- [Support Request](https://tosska.com/support-request/)
- [Tosska In-memory Maestro (TIM™) for Oracle® - Buy License](https://tosska.com/tosska-in-memory-maestro-tim-for-oracle-buy-license/)
- [Privacy Policy & Copyright](https://tosska.com/privacy-policy-copyright/) - Tosska Technologies Privacy Statement Your privacy is important to us. To better protect your privacy, we provide this notice explaining how we process the information collected on this website. What Information Is Collected? On the Tosska Technologies website you can browse information, order products, submit support request, and / or fill out other request forms.
- [Terms Of Use](https://tosska.com/terms-of-use/) - Notice PLEASE READ THESE TERMS AND CONDITIONS CAREFULLY. BY ACCESSING THIS SITE AND ANY PAGES THEREOF, YOU AGREE TO BE BOUND BY THE TERMS AND CONDITIONS BELOW. IF YOU DO NOT AGREE TO THE TERMS AND CONDITIONS BELOW, DO NOT ACCESS THIS SITE OR ANY PAGES THEREOF. Copyright © Tosska Technologies Limited. All Rights Reserved. Intellectual Property
- [Contact Us](https://tosska.com/contact-us/)
- [Shop](https://tosska.com/shop/)

## Products

- [Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® 4.8.2 - Free Upgrade](https://tosska.com/product/tosska-sql-tuning-expert-pro-tse-pro-for-oracle-4-8-2-free-upgrade/) - Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® is an intelligent SQL tuning tool for users to improve SQL performance with or without touching their program source code. Users can even deploy different performance query plans for various sizes of production databases without the effort of keeping multiple versions of the program source, it is especially suitable for package application users who don’t own the source code of their applications. Apart from the intelligent SQL tuning features, a powerful indexes recommendation function is also provided to help users to review and explore more potential indexes that are helpful but may be missing in current database schema.
- [Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® 5.0.0 - Free Upgrade](https://tosska.com/product/tosska-sql-tuning-expert-pro-tse-pro-for-oracle-5-0-0-free-upgrade/) - Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® is an intelligent SQL tuning tool for users to improve SQL performance with or without touching their program source code. Users can even deploy different performance query plans for various sizes of production databases without the effort of keeping multiple versions of the program source, it is especially suitable for package application users who don’t own the source code of their applications. Apart from the intelligent SQL tuning features, a powerful indexes recommendation function is also provided to help users to review and explore more potential indexes that are helpful but may be missing in current database schema.
- [Maintenance Renewal - Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle®](https://tosska.com/product/maintenance-renewal-tosska-sql-tuning-expert-pro-tse-pro-for-oracle/) - Please select the appropriate connection type to renew your maintenance. Customers on maintenance are entitled to free TSE Pro™ release and version upgrades.
- [Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® 5.0.0](https://tosska.com/product/tosska-sql-tuning-expert-pro-tse-pro-for-oracle-5-0-0/) - Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® is an intelligent SQL tuning tool for users to improve SQL performance with or without touching their program source code. Users can even deploy different performance query plans for various sizes of production databases without the effort of keeping multiple versions of the program source, it is especially suitable for package application users who don’t own the source code of their applications. Apart from the intelligent SQL tuning features, a powerful indexes recommendation function is also provided to help users to review and explore more potential indexes that are helpful but may be missing in current database schema. TSE Pro™ version 4 also provides state-of-the-art A.I. SQL Rewrite plus Hints Injection technology to rewrite a problematic SQL statement by exploring the potential best SQL syntax and hints injection that even an experienced developer cannot discover.
- [Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss® 1.8.1 - Free Upgrade](https://tosska.com/product/tosska-sql-tuning-expert-pro-tseg-pro-for-opengauss-1-8-1-free-upgrade/) - Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss® is an intelligent SQL tuning tool targeted for the openGauss database for users to improve SQL performance with or without touching their program source code. Users can even deploy different performance query plans using openGauss hints for various sizes of production databases without the effort of keeping multiple versions of the program source, it is especially suitable for package application users who don’t own the source code of their applications. Apart from the intelligent SQL tuning features, a powerful indexes recommendation function is also provided to help users to review and explore more potential indexes that are helpful but may be missing in current database schema.
- [Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss® 1.8.1](https://tosska.com/product/tosska-sql-tuning-expert-pro-tseg-pro-for-opengauss-1-8-1/) - Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss® is an intelligent SQL tuning tool for the openGauss database. TSEG Pro™ uses state-of-the-art A.I. SQL Rewrite plus Hints Injection technology to rewrite a problematic SQL statement by exploring the potential best SQL syntax and hints injection that even an experienced developer cannot discover. TSEG Pro™ also has a powerful indexes recommendation function to help users to review and explore more potential indexes that are helpful but may be missing in current database schema.
- [Tosska DB Ace Enterprise (DBAM™) for MySQL® 2.0.4 - Free Upgrade](https://tosska.com/product/tosska-db-ace-enterprise-dbam-for-mysql-2-0-4-free-upgrade/) - Tosska DB Ace Enterprise (DBAM™) for MySQL® is an innovative and groundbreaking tool designed for MySQL, offering comprehensive insights into your database performance. It allows you to monitor the individual SQL execution behavior while providing a broader view of your overall database performance. Equipped with powerful A.I.-powered SQL tuning functions, DB Ace Enterprise empowers users to optimize their SQL performance, whether or not source code modification is required.
- [Tosska DB Ace Enterprise (DBAM™) for MySQL® 3.0.0](https://tosska.com/product/tosska-db-ace-enterprise-dbam-for-mysql-3-0-0/) - Tosska DB Ace Enterprise (DBAM™) for MySQL® is an innovative and groundbreaking tool designed for MySQL, offering comprehensive insights into your database performance. It allows you to monitor the individual SQL execution behavior while providing a broader view of your overall database performance. Equipped with powerful A.I.-powered SQL tuning functions, DB Ace Enterprise empowers users to optimize their SQL performance, whether or not source code modification is required.
- [Tosska DB Ace Enterprise (DBAM™) for MySQL® 3.0.0 - Free Upgrade](https://tosska.com/product/tosska-db-ace-enterprise-dbam-for-mysql-3-0-0-free-upgrade/) - Tosska DB Ace Enterprise (DBAM™) for MySQL® is an innovative and groundbreaking tool designed for MySQL, offering comprehensive insights into your database performance. It allows you to monitor the individual SQL execution behavior while providing a broader view of your overall database performance. Equipped with powerful A.I.-powered SQL tuning functions, DB Ace Enterprise empowers users to optimize their SQL performance, whether or not source code modification is required.
- [Tosska DB Ace Enterprise (DBAO™) for Oracle® 4.0.0](https://tosska.com/product/tosska-db-ace-enterprise-dbao-for-oracle-4-0-0/) - An innovative tool that streamlines the process from performance prediction, problem identification to tuning resolution within one product. It shows you individual SQL execution behavior as well as the big picture of your overall database performance. It helps you to track and forecast database performance changes in different environments and comes with powerful A.I. SQL tuning functions to solve SQL performance problems.
- [Tosska DB Ace Enterprise (DBAO™) for Oracle® 4.0.0 - Free Upgrade](https://tosska.com/product/tosska-db-ace-enterprise-dbao-for-oracle-4-0-0-free-upgrade/) - Free version upgrade is only available for customers on active DBAO™ maintenance. Customers in maintenance grace period must renew their maintenance before they are entitled to free version upgrades.
- [Tosska DB Ace Enterprise (DBAP™) for PostgreSQL® 1.1.0 - Free Upgrade](https://tosska.com/product/tosska-db-ace-enterprise-dbap-for-postgresql-1-1-0-free-upgrade/) - Free version upgrade is only available for customers on active DBAP™ maintenance. Customers in maintenance grace period must renew their maintenance before they are entitled to free version upgrades.
- [Tosska DB Ace Enterprise (DBAP™) for PostgreSQL® 1.1.0](https://tosska.com/product/tosska-db-ace-enterprise-dbap-for-postgresql-1-1-0/) - Tosska DB Ace Enterprise (DBAP™) for PostgreSQL® is a complete SQL tuning solution that provides the world's leading automatic SQL syntax rewrite, Query Hints injection and AI based index recommendation to maximize the performance of a SQL statement for PostgreSQL with or without the source code. It automatically identify top slowest queries with full details so users can proactively eliminate bottlenecks.
- [Maintenance Renewal - Tosska DB Ace Enterprise for PostgreSQL® (DBAP™)](https://tosska.com/product/maintenance-renewal-tosska-db-ace-enterprise-for-postgresql-dbap/) - Please select the appropriate License Level to renew your maintenance. Customers on maintenance are entitled to free DBAP™ release and version upgrades.
- [Tosska DB Ace Enterprise (DBAM™) for MySQL® 2.0.4](https://tosska.com/product/tosska-db-ace-enterprise-dbam-for-mysql-2-0-4/) - Tosska DB Ace Enterprise (DBAM™) for MySQL® is an innovative and groundbreaking tool designed for MySQL, offering comprehensive insights into your database performance. It allows you to monitor the individual SQL execution behavior while providing a broader view of your overall database performance. Equipped with powerful A.I.-powered SQL tuning functions, DB Ace Enterprise empowers users to optimize their SQL performance, whether or not source code modification is required.
- [Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® 4.8.2](https://tosska.com/product/tosska-sql-tuning-expert-pro-tse-pro-for-oracle-4-8-2/) - Tosska SQL Tuning Expert Pro (TSE Pro™) for Oracle® is an intelligent SQL tuning tool for users to improve SQL performance with or without touching their program source code. Users can even deploy different performance query plans for various sizes of production databases without the effort of keeping multiple versions of the program source, it is especially suitable for package application users who don’t own the source code of their applications. Apart from the intelligent SQL tuning features, a powerful indexes recommendation function is also provided to help users to review and explore more potential indexes that are helpful but may be missing in current database schema. TSE Pro™ version 4 also provides state-of-the-art A.I. SQL Rewrite plus Hints Injection technology to rewrite a problematic SQL statement by exploring the potential best SQL syntax and hints injection that even an experienced developer cannot discover.
- [Tosska DB Ace Enterprise (DBAO™) for Oracle® 3.2.2 - Free Upgrade](https://tosska.com/product/tosska-db-ace-enterprise-dbao-for-oracle-3-2-2-free-upgrade/) - Free version upgrade is only available for customers on active DBAO™ maintenance. Customers in maintenance grace period must renew their maintenance before they are entitled to free version upgrades.
- [Tosska DB Ace Enterprise (DBAO™) for Oracle® 3.2.2](https://tosska.com/product/tosska-db-ace-enterprise-dbao-for-oracle-3-2-2/) - An innovative tool that streamlines the process from performance prediction, problem identification to tuning resolution within one product. It shows you individual SQL execution behavior as well as the big picture of your overall database performance. It helps you to track and forecast database performance changes in different environments and comes with powerful A.I. SQL tuning functions to solve SQL performance problems.
- [Tosska DB Ace Enterprise (DBAS™) for SQL Server® 2.1.3 - Free Upgrade](https://tosska.com/product/tosska-db-ace-enterprise-dbas-for-sql-server-2-1-3-free-upgrade/) - Free version upgrade is only available for customers on active DBAS™ maintenance. Customers in maintenance grace period must renew their maintenance before they are entitled to free version upgrades.
- [Tosska DB Ace Enterprise (DBAS™) for SQL Server® 2.1.3](https://tosska.com/product/tosska-db-ace-enterprise-dbas-for-sql-server-2-1-3/) - Tosska DB Ace Enterprise (DBAS™) for SQL Server® is a complete SQL tuning solution that provides the world's leading automatic SQL syntax rewrite, Query Hints injection, Plan Guide SQL tuning, Query Store SQL tuning, and index recommendation to maximize the performance of a SQL statement for MS SQL Server.
- [Maintenance Renewal - Tosska SQL Tuning Expert Pro (TSEG Pro™) for openGauss®](https://tosska.com/product/maintenance-renewal-tosska-sql-tuning-expert-pro-tseg-pro-for-opengauss/) - Please select the appropriate License Pack to renew your maintenance. Customers on maintenance are entitled to free TSEG Pro™ release and version upgrades.
- [Tosska SQL Tuning Expert (TSEM™) for MySQL® 2.3.3 - Free Upgrade](https://tosska.com/product/tosska-sql-tuning-expert-tsem-for-mysql-2-3-3-free-upgrade/)
- [Tosska SQL Tuning Expert for MySQL®  (TSEM™) 2.3.3](https://tosska.com/product/tosska-sql-tuning-expert-for-mysql-tsem-2-3-3/) - Tosska SQL Tuning Expert for MySQL® (TSEM™) is an innovative machine tuning tool for SQL statements for MySQL database. It optimizes SQL statements without the need of user's involvement. What you need to do is to input your problematic SQL statement into the product and press a button. You don't have to do analysis, guessing or testing during the entire SQL tuning process. The improved SQL statement will be benchmarked with your original SQL statement side by side without suspicion.
- [Maintenance Renewal - Tosska DB Ace Enterprise for MySQL® (DBAM™)](https://tosska.com/product/maintenance-renewal-tosska-db-ace-enterprise-for-mysql-dbam/) - Please select the appropriate License Level to renew your maintenance. Customers on maintenance are entitled to free DBAM™ release and version upgrades.
- [Maintenance Renewal - Tosska DB Ace Enterprise for SQL Server® (DBAS™)](https://tosska.com/product/maintenance-renewal-tosska-db-ace-enterprise-for-sql-server-dbas/) - Please select the appropriate License Level to renew your maintenance. Customers on maintenance are entitled to free DBAS™ release and version upgrades.
- [Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server® 2.1.1](https://tosska.com/product/tosska-sql-tuning-expert-pro-tses-pro-for-sql-server-2-1-1-v2/) - Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server® is an intelligent SQL tuning tool for the SQL Server database. TSES Pro™ uses state-of-the-art A.I. SQL Rewrite plus Hints Injection technology to rewrite a problematic SQL statement by exploring the potential best SQL syntax and hints injection that even an experienced developer cannot discover. TSES Pro™ also has a powerful indexes recommendation function to help users to review and explore more potential indexes that are helpful but may be missing in current database schema.
- [Maintenance Renewal - Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server®](https://tosska.com/product/maintenance-renewal-tosska-sql-tuning-expert-pro-tses-pro-for-sql-server/) - Please select the appropriate License Pack to renew your maintenance. Customers on maintenance are entitled to free TSES Pro™ release and version upgrades.
- [Maintenance Renewal - Tosska DB Ace Enterprise for Oracle® (DBAO™)](https://tosska.com/product/maintenance-renewal-tosska-db-ace-enterprise-for-oracle-dbao/) - Please select the appropriate License Level to renew your maintenance. Customers on maintenance are entitled to free DBAO™ release and version upgrades.
- [Tosska SQL Tuning Expert for Oracle®  (TSE™) 4.6.0](https://tosska.com/product/tosska-sql-tuning-expert-for-oracle-tse-4-6-0/) - Tosska SQL Tuning Expert (TSE™) for Oracle® is an innovative machine tuning tool for SQL statements. It optimizes SQL statements without the need of user's involvement. What you need to do is to input your problematic SQL statement into the product and press a button. You don't have to do analysis, guessing or testing during the entire SQL tuning process. The improved SQL statement will be benchmarked with your original SQL statement side by side without suspicion. TSE™ version 4 also provides state-of-the-art A.I. SQL Rewrite plus Hints Injection technology to rewrite a problematic SQL statement by exploring the potential best SQL syntax and hints injection that even an experienced developer cannot discover.
- [Tosska SQL Tuning Expert (TSE™) for Oracle® 4.6.0 - Free Upgrade](https://tosska.com/product/tosska-sql-tuning-expert-tse-for-oracle-4-6-0-free-upgrade/)
- [Tosska SQL Tuning Expert for MySQL <small>(5.1-5.5)</small>®  (TSEM5™) 2.3.0](https://tosska.com/product/tosska-sql-tuning-expert-for-mysql-5-1-5-5-tsem5-2-3-0/) - Tosska SQL Tuning Expert for MySQL (5.1-5.5)® (TSEM5™) is an innovative machine tuning tool for SQL statements for MySQL database v5.1-5.5. It optimizes SQL statements without the need of user's involvement. What you need to do is to input your problematic SQL statement into the product and press a button. You don't have to do analysis, guessing or testing during the entire SQL tuning process. The improved SQL statement will be benchmarked with your original SQL statement side by side without suspicion.
- [Tosska SQL Tuning Expert for SQL Server®  (TSES™) 1.5.1](https://tosska.com/product/tosska-sql-tuning-expert-for-sql-server-tses-1-5-1/) - Tosska SQL Tuning Expert for SQL Server® (TSES™) is an innovative machine tuning tool for SQL statements for SQL Server database. It is a one-button-solution that optimizes SQL statements automatically without the need of user's involvement. It provides powerful cold cache tuning and is probably the first SQL Server A.I. SQL tuning tool for SET ROWCOUNT N. You don't have to do analysis, guessing or testing during the entire SQL tuning process. The improved SQL statement will be benchmarked with your original SQL statement side by side without suspicion.
- [Tosska SQL Tuning Expert (TSES™) for SQL Server® 1.5.1 - Free Upgrade](https://tosska.com/product/tosska-sql-tuning-expert-tses-for-sql-server-1-5-1-free-upgrade/)
- [Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server® 2.1.1 - Free Upgrade](https://tosska.com/product/tosska-sql-tuning-expert-pro-tses-pro-for-sql-server-2-1-1-free-upgrade/) - Tosska SQL Tuning Expert Pro (TSES Pro™) for SQL Server® is an intelligent SQL tuning tool for users to improve SQL performance for the SQL Server database. TSES Pro™ provides state-of-the-art A.I. SQL Rewrite plus Hints Injection technology to rewrite a problematic SQL statement by exploring the potential best SQL syntax and hints injection that even an experienced developer cannot discover. Apart from the intelligent SQL tuning features, TSES Pro™ also has a powerful indexes recommendation function to help users to review and explore more potential indexes that are helpful but may be missing in current database schema.
- [Tosska In-Memory Maestro (TIM™) for Oracle® 1.2.0 - Free Upgrade](https://tosska.com/product/tosska-memory-maestro-tim-oracle-1-2-0-free-upgrade/)
- [Tosska In-Memory Maestro (TIM™) for Oracle® 1.2.0](https://tosska.com/product/tosska-memory-maestro-tim-oracle-1-2-0/) - Tosska In-memory Maestro (TIM™) for Oracle® automates the In-memory SQL optimization process and provide In-memory objects recommendations for a given SQL workload with our proprietary artificial intelligent engine. Tosska In-memory Maestro (TIM™) also provides user friendly In-memory simulation function for user to virtually evaluate their in-memory table objects for one SQL or a given SQL workload captured from SGA or AWR without actually populating those table objects.

## Categories

- [Uncategorized](https://tosska.com/category/uncategorized/)
- [Product](https://tosska.com/category/product/)
- [Free Trial](https://tosska.com/category/free-trial/)
- [Buy](https://tosska.com/category/buy/)
- [Support](https://tosska.com/category/support/)
- [Doc](https://tosska.com/category/doc/)
- [FAQ](https://tosska.com/category/faq/)
- [Tips & Tricks](https://tosska.com/category/tips-tricks/)
- [News](https://tosska.com/category/news/)
- [New Release](https://tosska.com/category/new-release/)
- [Blogs](https://tosska.com/category/blogs/)
- [TSE](https://tosska.com/category/tse/)
- [Oracle Database Performance](https://tosska.com/category/oracle-database-performance/)
- [sql query](https://tosska.com/category/sql-query/)

## Tags

- [Tosska](https://tosska.com/tag/tosska/)
- [In-memory](https://tosska.com/tag/in-memory/)
- [Oracle](https://tosska.com/tag/oracle/)
- [database](https://tosska.com/tag/database/)
- [optimize](https://tosska.com/tag/optimize/)
- [TIM](https://tosska.com/tag/tosska-in-memory-maestro/) - Tosska’s flagship product that uses Tosska’s proprietary Artificial Intelligence technology to find the best possible in memory objects combination for best performance in the specific user environment.
- [TSE](https://tosska.com/tag/tosska-sql-tuning-expert/) - An advanced SQL tuning tool that uses Tosska’s proprietary ‘balance search’ algorithm to do ‘machine-tuning’ for selected SQL statements.
- [SQL Tuning](https://tosska.com/tag/sql-tuning/) - SQL (Structured Query Language) Tuning
- [SQL Optimization](https://tosska.com/tag/sql-optimization/)
- [OLAP](https://tosska.com/tag/olap/)
- [SQL](https://tosska.com/tag/sql/)
- [hints](https://tosska.com/tag/hints/)
- [TSE Pro](https://tosska.com/tag/tse-pro/)
- [oracle database and sql](https://tosska.com/tag/oracle-database-and-sql/)
- [sql performance tuning](https://tosska.com/tag/sql-performance-tuning/)
- [improve oracle database performance](https://tosska.com/tag/improve-oracle-database-performance/)
- [oracle database performance tuning](https://tosska.com/tag/oracle-database-performance-tuning/)
- [TSEM](https://tosska.com/tag/tsem/) - Tosska SQL Tuning Expert for MySQL
- [improve MySQL database performance](https://tosska.com/tag/improve-mysql-database-performance/)
- [performance tuning in SQL MySQL](https://tosska.com/tag/performance-tuning-in-sql-mysql/)
- [MySQL sql performance tuning](https://tosska.com/tag/mysql-sql-performance-tuning/)
- [MySQL database and sql](https://tosska.com/tag/mysql-database-and-sql/)
- [sql tuning for MySQL](https://tosska.com/tag/sql-tuning-for-mysql/)
- [COUNT(*) statements](https://tosska.com/tag/count-statements/)
- [order by rand() limit](https://tosska.com/tag/order-by-rand-limit/)
- [substr() SQL](https://tosska.com/tag/substr-sql/)
- [Order by Limit N](https://tosska.com/tag/order-by-limit-n/)
- [SQL with OR](https://tosska.com/tag/sql-with-or/)
- [UPDATE SQL statement with IN subquery](https://tosska.com/tag/update-sql-statement-with-in-subquery/)
- [Statement with multiple MAX() functions](https://tosska.com/tag/statement-with-multiple-max-functions/)
- [“Not Exists” SQL](https://tosska.com/tag/not-exists-sql/)
- [CTE “WITH” statement](https://tosska.com/tag/cte-with-statement/)
- [Tune Delete SQL statement](https://tosska.com/tag/tune-delete-sql-statement/)
- [SQL with LIKE '%ROGER%' Expression](https://tosska.com/tag/sql-with-like-roger-expression/)
- [Statement with Multiple OR Subqueries](https://tosska.com/tag/statement-with-multiple-or-subqueries/)
- [SQL with IN List Bind Variables](https://tosska.com/tag/sql-with-in-list-bind-variables/)
- [SQL with Multiple Union in Subquery](https://tosska.com/tag/sql-with-multiple-union-in-subquery/)
- [SQL with SEMI JOIN](https://tosska.com/tag/sql-with-semi-join/)
- [SQL with Exists Operator](https://tosska.com/tag/sql-with-exists-operator/)
- [SQL with IN Subquery](https://tosska.com/tag/sql-with-in-subquery/)
- [SQL Statement with Driving Path Control](https://tosska.com/tag/sql-statement-with-driving-path-control/)
- [SQL with DECODE Expression](https://tosska.com/tag/sql-with-decode-expression/)
- [SQL statement with Transitive Dependency Improvement](https://tosska.com/tag/sql-statement-with-transitive-dependency-improvement/)
- [sql tuning for oracle](https://tosska.com/tag/sql-tuning-for-oracle/)
- [optimization in sql](https://tosska.com/tag/optimization-in-sql/)
- [optimize oracle query](https://tosska.com/tag/optimize-oracle-query/)
- [query tuning in sql](https://tosska.com/tag/query-tuning-in-sql/)
- [TSES](https://tosska.com/tag/tses/)
- [SQL Statements with CONCAT Operator](https://tosska.com/tag/sql-statements-with-concat-operator/)
- [SQL Server performance improvement](https://tosska.com/tag/sql-server-performance-improvement/)
- [SQL Server database and SQL](https://tosska.com/tag/sql-server-database-and-sql/)
- [improve SQL Server performance](https://tosska.com/tag/improve-sql-server-performance/)
- [SQL Server SQL performance tuning](https://tosska.com/tag/sql-server-sql-performance-tuning/)
- [SQL tuning SQL Server](https://tosska.com/tag/sql-tuning-sql-server/)
- [SQL Statement with IN Operator with an Expression List](https://tosska.com/tag/sql-statement-with-in-operator-with-an-expression-list/)
- [SQL Statement with EXISTS Subquery](https://tosska.com/tag/sql-statement-with-exists-subquery/)
- [improve performance of sql query](https://tosska.com/tag/improve-performance-of-sql-query/)
- [query performance tuning](https://tosska.com/tag/query-performance-tuning/)
- [database query optimization](https://tosska.com/tag/database-query-optimization/)
- [optimization of sql queries](https://tosska.com/tag/optimization-of-sql-queries/)
- [sql performance monitoring](https://tosska.com/tag/sql-performance-monitoring/)
- [Cold Cache](https://tosska.com/tag/cold-cache/)
- [SET ROWCOUNT](https://tosska.com/tag/set-rowcount/)
- [Oracle SQL performance tuning](https://tosska.com/tag/oracle-sql-performance-tuning/)
- [SLOWER but BETTER](https://tosska.com/tag/slower-but-better/)
- [Statement with “< ANY (subquery)” Operator](https://tosska.com/tag/statement-with-any-subquery-operator/)
- [TSEM5](https://tosska.com/tag/tsem5/)
- [Tune SQL Statements to Run SLOWER](https://tosska.com/tag/tune-sql-statements-to-run-slower/)
- [SQL Statement with OR conditions](https://tosska.com/tag/sql-statement-with-or-conditions/)
- [SQL Server query optimizer tool](https://tosska.com/tag/sql-server-query-optimizer-tool/)
- [SQL Statement with CASE Expression](https://tosska.com/tag/sql-statement-with-case-expression/)
- [SQL Statements with Rewrite and Hints Injection](https://tosska.com/tag/sql-statements-with-rewrite-and-hints-injection/)
- [SQL query optimization tool online](https://tosska.com/tag/sql-query-optimization-tool-online/)
- [download free SQL Server](https://tosska.com/tag/download-free-sql-server/)
- [free SQL tools for Windows](https://tosska.com/tag/free-sql-tools-for-windows/)
- [oracle sql query](https://tosska.com/tag/oracle-sql-query/)
- [sql optimizer for sql server](https://tosska.com/tag/sql-optimizer-for-sql-server/)
- [dba tuning](https://tosska.com/tag/dba-tuning/)
- [SQL query performance tuning](https://tosska.com/tag/sql-query-performance-tuning/)
- [Oracle database and SQL Server](https://tosska.com/tag/oracle-database-and-sql-server/)
- [MySQL database](https://tosska.com/tag/mysql-database/)
- [index](https://tosska.com/tag/index/)
- [concatenated indexes](https://tosska.com/tag/concatenated-indexes/)
- [tune a SQL that cannot be tuned](https://tosska.com/tag/tune-a-sql-that-cannot-be-tuned/)
- [SQL Server performance tuning](https://tosska.com/tag/sql-server-performance-tuning/)
- [query optimization in SQL Server](https://tosska.com/tag/query-optimization-in-sql-server/)
- [Tune SQL Statement with CASE Expression](https://tosska.com/tag/tune-sql-statement-with-case-expression/)
- [SQL Statements with NO_RANGE_OPTIMIZATION](https://tosska.com/tag/sql-statements-with-no_range_optimization/)
- [ORDERED Hint to Tune a SQL with subquery](https://tosska.com/tag/ordered-hint-to-tune-a-sql-with-subquery/)
- [sql server tuning tools](https://tosska.com/tag/sql-server-tuning-tools/)
- [TSES Pro](https://tosska.com/tag/tses-pro/)
- [SQL Server](https://tosska.com/tag/sql-server/)
- [Oracle Performance](https://tosska.com/tag/oracle-performance/)
- [Create Index Oracle](https://tosska.com/tag/create-index-oracle/)
- [MySQL query optimization](https://tosska.com/tag/mysql-query-optimization/)
- [composite index](https://tosska.com/tag/composite-index/)
- [order of columns](https://tosska.com/tag/order-of-columns/)
- [build indexes for multiple Max() functions](https://tosska.com/tag/build-indexes-for-multiple-max-functions/)
- [FORCE INDEX Hints](https://tosska.com/tag/force-index-hints/)
- [FORCE INDEX](https://tosska.com/tag/force-index/)
- [oracle performance tuning tips](https://tosska.com/tag/oracle-performance-tuning-tips/)
- [oracle database](https://tosska.com/tag/oracle-database/)
- [index SQL with aggregate function SQL](https://tosska.com/tag/index-sql-with-aggregate-function-sql/)
- [slow first execution SQL](https://tosska.com/tag/slow-first-execution-sql/)
- [build index](https://tosska.com/tag/build-index/)
- [use ROWID to improve an UPDATE statement](https://tosska.com/tag/use-rowid-to-improve-an-update-statement/)
- [LCASE function on index](https://tosska.com/tag/lcase-function-on-index/)
- [CASE Expression](https://tosska.com/tag/case-expression/)
- [Tune SQL with IN Subquery](https://tosska.com/tag/tune-sql-with-in-subquery/)
- [Intersect](https://tosska.com/tag/intersect/)
- [DBAO](https://tosska.com/tag/dbao/)
- [Tune SQL with DB Link](https://tosska.com/tag/tune-sql-with-db-link/)
- [80/20 Rule](https://tosska.com/tag/80-20-rule/)
- [DBAS](https://tosska.com/tag/dbas/)
- [Use 80/20 Rule To Tune SQL](https://tosska.com/tag/use-80-20-rule-to-tune-sql/)
- [query store](https://tosska.com/tag/query-store/)
- [Tune SQL with Query Store](https://tosska.com/tag/tune-sql-with-query-store/)
- [impact of a database environment change](https://tosska.com/tag/impact-of-a-database-environment-change/)
- [what-if analysis](https://tosska.com/tag/what-if-analysis/)
- [Performance Deployment in Software Deployment](https://tosska.com/tag/performance-deployment-in-software-deployment/)
- [tune Ad-hoc SQL](https://tosska.com/tag/tune-ad-hoc-sql/)
- [Plan Guide](https://tosska.com/tag/plan-guide/)
- [tune SQL in a Database Object with Plan Guide](https://tosska.com/tag/tune-sql-in-a-database-object-with-plan-guide/)
- [DBAM](https://tosska.com/tag/dbam/)
- [Query Rewriter Plugin](https://tosska.com/tag/query-rewriter-plugin/)
- [Query Rewriter](https://tosska.com/tag/query-rewriter/)
- [TSEG Pro](https://tosska.com/tag/tseg-pro/)
- [opengauss](https://tosska.com/tag/opengauss/)
- [Tune SQL with “Exists subquery”](https://tosska.com/tag/tune-sql-with-exists-subquery/)
- [Tune CASE Expression](https://tosska.com/tag/tune-case-expression/)
- [TSEP Pro](https://tosska.com/tag/tsep-pro/)
- [PostgreSQL](https://tosska.com/tag/postgresql/)
- [database index](https://tosska.com/tag/database-index/)
- [IN subquery](https://tosska.com/tag/in-subquery/)
- [SQL tuning for PostgreSQL](https://tosska.com/tag/sql-tuning-for-postgresql/)
- [NOT IN subquery](https://tosska.com/tag/not-in-subquery/)
- [DBAP](https://tosska.com/tag/dbap/)

## Product categories

- [TIM](https://tosska.com/product-category/tim/)
- [TSE](https://tosska.com/product-category/tse/)
- [TSE Pro](https://tosska.com/product-category/tse/tse-pro/) - Tosska SQL Tuning Expert Pro series
- [TSEM](https://tosska.com/product-category/tsem/)
- [TSES](https://tosska.com/product-category/tses/)
- [TSEM5](https://tosska.com/product-category/tsem5/)
- [TSES Pro](https://tosska.com/product-category/tses/tses-pro/)
- [DBAO](https://tosska.com/product-category/dbao/) - DB Ace Enterprise for Oracle
- [DBAS](https://tosska.com/product-category/dbas/)
- [DBAM](https://tosska.com/product-category/dbam/)
- [TSEG](https://tosska.com/product-category/tseg/)
- [TSEG Pro](https://tosska.com/product-category/tseg/tseg-pro/)
- [DBAP](https://tosska.com/product-category/dbap/)