Expand my Community achievements bar.

Klaster
Klaster
Offline
Type
  • All
  • Questions
  • Discussions
  • Ideas
  • Blogs
Filter by user contributions
  • Hi, I have found that table NmsBroadLogRcp is updated in batches For ex. likeUPDATE NmsBroadLogRcp SET iStatus=:1, iMsgId=:2, tsEvent=:3, tsLastModified=cast(SYSTIMESTAMP as TIMESTAMP WITH TIME ZONE) WHERE iDeliveryId=:4 AND iStatus=:5 AND ROWNUM<=5000 I'm looking for solution how to manage batch si...

    Type

    Questions

    Views

    2.5K

    Likes

    0

    Replies

    1
  • Probably yes,It looks like comment - it informs database how process queryfor ex.SELECT /*+ LEADING(e2 e1) USE_NL(e1) INDEX(e1 emp_emp_id_pk)   USE_MERGE(j) FULL(j) */  e1.first_name, e1.last_name, j.job_id, sum(e2.salary) total_sal  FROM employees e1, employees e2, job_history j  WHERE e1.employee_...

    Type

    Questions

    Views

    1.6K

    Likes

    0

    Replies

    0
  • Good morning,Is possible to use hints for queries generated ? For example those that change join path order.

    Type

    Questions

    Views

    2.1K

    Like

    1

    Replies

    3
Top badges earned by Klaster
Customize the badges you want to showcase on your profile