slow sql

Page 2 of 4
  1. 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
  2. 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
  3. Richard To
    Thread

    How to Tune Cold Cache SQL Statements for SQL Server?

    For SQL statements that are not executed frequently, so that the relevant data is no longer exists in the buffer cache, a cold cache will...
    Thread by: Richard To, May 5, 2021, 0 replies, in forum: SQL Server
  4. Richard To
    Thread

    How to Tune Bad Performance SET ROWCOUNT SQL Statements for SQL Server?

    Some SQL statements will be running very slow after SET ROWCOUNT or TOP is used. SET ROWCOUNT and TOP are used to tell SQL Server to select a...
    Thread by: Richard To, Apr 28, 2021, 0 replies, in forum: SQL Server
  5. 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
  6. Richard To
    Thread

    How to Tune SQL Statement with IN Operator with an Expression List for SQL Server?

    The following is an example shows a SQL statement with an IN List expression. The SQL retrieves records from EMPLOYEE table that EMP_DEPT should...
    Thread by: Richard To, Apr 7, 2021, 0 replies, in forum: SQL Server
  7. 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
  8. 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
  9. Richard To
    Thread

    How to Tune SQL Statements with CONCAT Operator for MySQL?

    There may be some business requirements that need to compare concatenate strings and column with a given unknown length of the bind variable....
    Thread by: Richard To, Feb 19, 2021, 0 replies, in forum: MySQL
  10. Richard To
    Thread

    How to Tune SQL Statement with DECODE Expression for Oracle?

    Here the following is an example SQL statement with a DECODE expression syntax. select * from employee where decode(emp_dept, 'AAA',...
    Thread by: Richard To, Feb 1, 2021, 0 replies, in forum: Oracle
  11. Richard To
    Thread

    How to Tune SQL statement with Transitive Dependency Improvement for MySQL?

    The following is an example shows a SQL statement with two conditions “emp_dept=dpt_id and emp_dept<'L'” . select * from employee, department...
    Thread by: Richard To, Jan 22, 2021, 0 replies, in forum: MySQL
  12. Richard To
    Thread

    How to Tune SQL with IN Subquery in Certain Environment for Oracle ?

    Here is an example SQL that retrieves data from EMPLOYEE table with employee’s ID code in EMP_SUBSIDIARY table. select * from employee a where...
    Thread by: Richard To, Jan 13, 2021, 0 replies, in forum: Oracle
  13. Richard To
    Thread

    How to Tune SQL Statement with Driving Path Control for MySQL?

    The following is an example shows a SQL statement with two potential table join paths. “Employee to Department” and “Department to Employee” are...
    Thread by: Richard To, Jan 4, 2021, 0 replies, in forum: MySQL
  14. Richard To
    Thread

    How to Tune SQL with Exists Operator in Certain Environment for Oracle?

    Here is an example SQL that retrieves data from EMPLOYEE table with “emp_id < 710000” and employee’s department code exists in DEPARTMENT table....
    Thread by: Richard To, Dec 18, 2020, 0 replies, in forum: Oracle
  15. Richard To
    Thread

    How to Tune SQL Statement with IN List Bind Variables for MySQL?

    The following is an example shows a SQL statement with a variable on the IN List operator. The SQL retrieve records from EMPLOYEE table that...
    Thread by: Richard To, Dec 10, 2020, 0 replies, in forum: MySQL
  16. Richard To
    Thread

    How to Tune SQL with SEMI JOIN by Hints INDEX_DESC Injection for Oracle?

    Semi-join is introduced in Oracle 8.0. It provides an efficient method of performing a WHERE EXISTS or WHERE IN sub-queries. A semi-join returns...
    Thread by: Richard To, Dec 6, 2020, 0 replies, in forum: Oracle
  17. Richard To
    Thread

    How to Tune SQL Statement with Multiple Union in Subquery for MySQL?

    The following is an example shows a SQL statement with two union operator in a subquery. The SQL retrieve records from EMPLOYEE table that EMP_ID...
    Thread by: Richard To, Nov 30, 2020, 0 replies, in forum: MySQL
  18. Richard To
    Thread

    How to Tune SQL with LIKE '%ROGER%' SQL Statements for Oracle?

    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, Nov 26, 2020, 0 replies, in forum: Oracle
  19. Richard To
    Thread

    How to Tune Delete SQL statement with subqueries for MySQL?

    The following is an example shows a DELETE SQL statement with subquery. The SQL delete records from emp_subsidiary that should satisfy with three...
    Thread by: Richard To, Nov 23, 2020, 0 replies, in forum: MySQL
  20. Richard To
    Thread

    How to Tune SQL Statement with Multiple OR Subqueries for Oracle?

    Here the following is SQL statement with multiple OR subqueries. SELECT * FROM employee WHERE emp_id IN (SELECT emp_id FROM emp_subsidiary where...
    Thread by: Richard To, Nov 16, 2020, 0 replies, in forum: Oracle
Showing results 21 to 40 of 63
Page 2 of 4
  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