slow sql

Page 3 of 3
  1. Richard To
    Thread

    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...
    Thread by: Richard To, Sep 21, 2020, 0 replies, in forum: MySQL
  2. Richard To
    Thread

    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...
    Thread by: Richard To, Sep 14, 2020, 0 replies, in forum: MySQL
  3. Richard To
    Thread

    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....
    Thread by: Richard To, Sep 7, 2020, 0 replies, in forum: MySQL
  4. Richard To
    Thread

    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...
    Thread by: Richard To, Aug 31, 2020, 0 replies, in forum: MySQL
  5. Richard To
    Thread

    How to tune Substr(emp_name,x,y) 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...
    Thread by: Richard To, Aug 24, 2020, 0 replies, in forum: MySQL
  6. Richard To
    Thread

    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...
    Thread by: Richard To, Aug 17, 2020, 0 replies, in forum: MySQL
  7. Richard To
    Thread

    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...
    Thread by: Richard To, Aug 6, 2020, 0 replies, in forum: MySQL
  8. Richard To
    Thread

    Introduce a world’s Leading A.I. SQL Rewrite technology for MySQL database

    World’s Leading A.I. SQL Rewrite technology for MySQL database Manually rewriting SQL syntax to tune a SQL statement is commonly adopted by...
    Thread by: Richard To, Aug 1, 2020, 0 replies, in forum: MySQL
  9. Richard To
    Thread

    How to tune SQL with Like '%ABC%'

    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...
    Thread by: Richard To, Jun 24, 2020, 0 replies, in forum: MySQL
  10. Richard To
    Thread

    A new MySQL SQL tuning tool

    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...
    Thread by: Richard To, Apr 14, 2020, 0 replies, in forum: MySQL
  11. Richard To
    Thread

    Adding new indexes or using hints to tune SQL statements?

    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...
    Thread by: Richard To, Nov 12, 2019, 0 replies, in forum: Oracle
  12. Richard To
    Thread

    Even the most experienced SQL tuning developer cannot do it?

    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...
    Thread by: Richard To, Oct 2, 2019, 0 replies, in forum: Oracle
  13. Richard To
    Thread

    How to use SQL Patches to tuning SQL without the need to change your source code

    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...
    Thread by: Richard To, Jul 19, 2019, 0 replies, in forum: Oracle
  14. Richard To
    Thread

    A SQL example to show why traditional SQL rewrite tuning may not be applicable

    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...
    Thread by: Richard To, Jun 5, 2019, 0 replies, in forum: Oracle
  15. Richard To
    Thread

    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....
    Thread by: Richard To, Mar 1, 2019, 0 replies, in forum: Oracle
  16. Richard To
    Thread

    Intelligent SQL tuning without touching your source code

    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...
    Thread by: Richard To, May 15, 2018, 1 replies, in forum: Oracle
  17. Richard To
    Thread

    Introduce a new machine tuning tool for SQL statements

    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...
    Thread by: Richard To, Dec 11, 2017, 1 replies, in forum: Oracle
Showing results 41 to 57 of 57
Page 3 of 3
  1. This site uses cookies to help personalise content, tailor your experience and to keep you logged in if you register.
    By continuing to use this site, you are consenting to our use of cookies.
    Accept Learn More...
    Dismiss Notice