tosska sql tuning

  1. Richard To
    Thread

    How to use Query Rewriter Plugin to tune SQL in MySQL database I

    The Query Rewriter Plugin in MySQL is a component that allows you to modify incoming SQL queries before execution. It provides the ability to...
    Thread by: Richard To, Dec 7, 2023, 0 replies, in forum: MySQL
  2. 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
  3. Richard To
    Thread

    How to tune SQL with Query Store for SQL Server?

    The Query Store feature in SQL Server serves as a valuable tool for troubleshooting performance issues by allowing users to quickly identify...
    Thread by: Richard To, Jul 6, 2023, 0 replies, in forum: SQL Server
  4. Richard To
    Thread

    How To Use 80/20 Rule To Tune A Database Application II?

    The previous article “How To Use 80/20 Rule To Tune A Database Application I “ demonstrated how the 80/20 Rule can be applied to evaluate the...
    Thread by: Richard To, Jul 3, 2023, 0 replies, in forum: Oracle
  5. Richard To
    Thread

    How To Use 80/20 Rule To Tune A Database Application I?

    In 2002, Microsoft reported that the majority of errors and crashes in their software were caused by a minority of the bugs they detected,...
    Thread by: Richard To, Jun 19, 2023, 0 replies, in forum: Oracle
  6. 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
  7. Richard To
    Thread

    How to Tune SQL Statement with CASE Expression by Hints Injection for Oracle?

    Here the following is a simple SQL statement with a CASE expression syntax. SELECT * FROM employee WHERE CASE WHEN emp_salary<...
    Thread by: Richard To, Oct 10, 2022, 0 replies, in forum: Oracle
  8. Richard To
    Thread

    How to use ROWID to improve an UPDATE statement for Oracle?

    Here the following is an Update SQL with a subquery that updates the EMPLOYEE table if the emp_dept satisfies the records returned from a...
    Thread by: Richard To, Jul 4, 2022, 0 replies, in forum: Oracle
  9. Richard To
    Thread

    How to build indexes for slow first execution SQL - SQL Server?

    You may suffer from SQL statements with a slow first execution time due to the long data cache process. The following SQL is simple that retrieves...
    Thread by: Richard To, Apr 14, 2022, 0 replies, in forum: SQL Server
  10. Richard To
    Thread

    How to use FORCE INDEX Hints to tune an UPDATE SQL statement?

    We used to use FORCE INDEX hints to enable an index search for a SQL statement if a specific index is not used. It is due to the database SQL...
    Thread by: Richard To, Feb 7, 2022, 0 replies, in forum: MySQL
  11. 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
  12. Richard To
    Thread

    How to Tune SQL Statement with OR conditions in a Subquery for SQL Server?

    The following is an example that shows a SQL statement with an EXISTS subquery. The SQL counts the records from the EMPLOYEE table if the OR...
    Thread by: Richard To, Jun 1, 2021, 0 replies, in forum: SQL Server
  13. Richard To
    Thread

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

    Here the following is a simple SQL statement with a “< ANY (Subquery)” syntax. SELECT * FROM employee WHERE emp_salary< ANY (SELECT emp_salary...
    Thread by: Richard To, May 12, 2021, 0 replies, in forum: Oracle
  14. Richard To
    Thread

    How to Tune SQL Statement with EXISTS Subquery for SQL Server II?

    In my last article How to Tune SQL Statement with EXISTS Subquery for SQL Server I? | Go4Expert that a SQL statement with an Exists subquery was...
    Thread by: Richard To, Apr 20, 2021, 0 replies, in forum: SQL Server
  15. Richard To
    Thread

    How to Tune SQL Statement with “Or Bind Variable is Null” Expression for Oracle?

    Here the following is an example SQL statement with an “Or Bind Variable is Null” expression syntax. SELECT * FROM EMPLOYEE WHERE...
    Thread by: Richard To, Mar 16, 2021, 0 replies, in forum: Oracle
Showing results 1 to 15 of 15
  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