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...
It is common that we used to count the number of records in a table. You may encounter unexpected performance degradation in certain situations....
The LIKE is a logical operator that determines if a character string matches a specified pattern. A pattern may include regular characters and...
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...
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...
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...
World’s Leading A.I. SQL Rewrite technology for MySQL database Manually rewriting SQL syntax to tune a SQL statement is commonly adopted by...
It is common we come across SQL with Like '%Alex%' in MySQL that no index will be used. Here is one of the rewrite solution that may help in your...
Tosska SQL Tuning Expert for MySQL It is not just another SQL tuning tool There are not many SQL tuning tools for MySQL database, but most of...
There are at least two commonly used methods to improve an SQL statement’s performance. First, users can influence Oracle SQL optimizer to pick up...
I came across with a SQL statement from a user as a testing case to our product, the SQL is joining 4 tables with data retrieved from system table...
SQL Patches is part of the features provided by SQL Repair Advisor which is used to fix a SQL statement’s critical failures such as returning...
A SQL statement with multiple aggregation functions like the following and the emps_salary and emps_id are indexed. If you find the SQL is slow...
The following SQL is simple, but the explain plan is a little bit complex. Oracle SQL optimizer uses an adaptive plan to execute the SQL...
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....
Introduction Application package software is a collection of software programs that is developed for the purpose of being licensed to third-party...
Tosska SQL Tuning Expert Pro for Oracle It is not another SQL Tuning tool There have been already a lot of SQL tuning products in the market...
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...
What is machine tuning for SQL statements? Tosska SQL Tuning Expert is a SQL tuning tool that optimizes your SQL statements without the need of...
Why use Oracle In-Memory database from another perspective A lot of people are talking about why or why not use Oracle In-memory database in their...
Separate names with a comma.
