Search:

Type: Posts; User: Richardto; Keyword(s):

Search: Search took 0.00 seconds.

  1. An innovative machine tuning tool for SQL statements

    Tosska SQL Tuning Expert for Oracle

    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 user’s...
  2. Replies
    3
    Views
    1,017

    You can use Oracle In-memory Advisor which can...

    You can use Oracle In-memory Advisor which can recommend tables objects into in-memory or Tosska IM Advisor, Oracle uses human hardcoded rule to recommend tables current workload, Tosska uses AI...
  3. There is no tool that can scan PL/SQL code to...

    There is no tool that can scan PL/SQL code to tell you the data flow, there are some tools in market such as Quest product can scan your database schema to give you ER diagram.
  4. Replies
    3
    Views
    1,017

    Due to the new In-memory objects populated for...

    Due to the new In-memory objects populated for the SQL will change the execution plan. Some complex SQL may be degraded due to the cost estimation problem by Oracle SQL optimizer, that is why Oracle...
  5. You can use this SQL: select col1,col2 from...

    You can use this SQL:

    select col1,col2 from DUPLICATE where col2 not in (select col1 from DUPLICATE)
  6. It seems Oracle optimizer made different...

    It seems Oracle optimizer made different execution plan in different environment, you can use Hints to influence Oracle optimizer. In your case, Hash join may be good.
Results 1 to 6 of 7