1. This site uses cookies. By continuing to use this site, you are agreeing to our use of cookies. Learn More.

sql optimizer

  1. Richard To
    Thread

    How to Tune SQL with “Group By” statement?

    The following is an example shows a SQL statement with “Group by” expression. The SQL retrieve the sum of historical salary from table...
    Thread by: Richard To, Nov 10, 2020, 0 replies, in forum: MySQL
  2. 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
  3. 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
Showing results 1 to 3 of 3