sql tuning

  1. Richard To
    Thread

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

    It is not just another SQL tuning tool There are not many SQL tuning tools for SQL Server database, but most of them are focused on plan...
    Thread by: Richard To, Apr 1, 2021, 0 replies, in forum: SQL Server
  2. 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
  3. Richard To
    Thread

    How to Tune SQL Statement with “< All (subquery)” Operator for Oracle?

    Here the following is a simple SQL statement with a “< ALL (Subquery)” syntax. SELECT * FROM employee a WHERE a.emp_salary <ALL(SELECT...
    Thread by: Richard To, Oct 26, 2020, 0 replies, in forum: Oracle
  4. Richard To
    Thread

    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”...
    Thread by: Richard To, Oct 5, 2020, 0 replies, in forum: MySQL
  5. 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
  6. 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
  7. 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
  8. 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
  9. 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
  10. 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
  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

    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
  13. Richard To
    Thread

    Speed up Aggregation Functions by Multiple Subqueries

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

    How to tune Oracle application packages’ SQL such as Siebel, PeopleSoft, and SAP

    Introduction Application package software is a collection of software programs that is developed for the purpose of being licensed to third-party...
    Thread by: Richard To, Sep 12, 2018, 1 replies, in forum: Oracle
  16. Richard To
    Thread

    Unlock the power of using Oracle Optimizer Hints to 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...
    Thread by: Richard To, Feb 8, 2018, 0 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
  18. Richard To
    Thread

    Why use Oracle In-Memory database from another perspective

    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...
    Thread by: Richard To, Sep 20, 2017, 0 replies, in forum: Oracle
Showing results 1 to 18 of 18
  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