Not a member of Pastebin yet?
Sign Up,
it unlocks many cool features!
- SELECT /*+ INDEX(i dcf_vol_prospect_ids_idx)*/
- /*+ LEADING(i vol) */
- /*+ ALL_ROWS */
- i.id_number,
- ...
- FROM i_table i
- JOIN vol_table vol on vol.id_number = i.id_number
- JOIN to_a_bunch_of_other_tables...
- WHERE i.solicitor_id = '123'
- AND vol.solicitable_ind = 1;
- 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_id = e2.manager_id
- AND e1.employee_id = j.employee_id
- AND e1.hire_date = j.start_date
- GROUP BY e1.first_name, e1.last_name, j.job_id ORDER BY total_sal;
Add Comment
Please, Sign In to add comment