sql tuning

Page 1 of 2
  1. Richard To
    Thread

    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...
    Thread by: Richard To, Aug 25, 2023, 0 replies, in forum: SQL Server
  2. Richard To
    Thread

    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...
    Thread by: Richard To, Aug 8, 2023, 0 replies, in forum: SQL Server
  3. Richard To
    Thread

    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...
    Thread by: Richard To, Jul 25, 2023, 0 replies, in forum: Oracle
  4. Richard To
    Thread

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

    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...
    Thread by: Richard To, Jun 9, 2023, 0 replies, in forum: Oracle
  6. Richard To
    Thread

    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...
    Thread by: Richard To, Apr 26, 2023, 0 replies, in forum: Oracle
  7. Richard To
    Thread

    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...
    Thread by: Richard To, Jan 24, 2022, 0 replies, in forum: SQL Server
  8. Richard To
    Thread

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

    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...
    Thread by: Richard To, Jun 16, 2021, 0 replies, in forum: Oracle
  10. Richard To
    Thread

    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...
    Thread by: Richard To, May 19, 2021, 0 replies, in forum: MySQL
  11. 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
  12. 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
  13. 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
  14. 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
  15. 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
  16. 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
  17. 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
  18. 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
  19. 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
  20. 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
Showing results 1 to 20 of 28
Page 1 of 2
  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