requette Explain Plan

**papyj** · 23/08/2007, 18h39

La requête suivante utilise un Explain Plan qui fait que la requête n'aboutit pas.
Si on l'exécute en mode RULE, l'EXPLAIN PLAN est différent et la requête ne prend que quelques secondes.

Il y a t’il une explication ?

Code :

Sélectionner tout - Visualiser dans une fenêtre à part

1
2
3
4
5
6
7
8
9
10
11
12
13
14
15
16
17
18
19
20
21
22
23
24
25
26
27
28
29
30
31
32
SELECT   batch_name, header_name, currency_code, line_je_line_num,
         line_description, line_accounted_cr, period_name, line_stat_amount,
         line_accounted_dr, header_effective_date, doc_sequence_value, row_id,
         line_entered_dr_num, line_entered_cr_num, actual_flag,
         batch_description, set_of_books_id, header_description,
         doc_sequence_id, je_batch_id, je_header_id, line_code_combination_id,
         line_period_name, line_effective_date, line_reference_1,
         line_reference_2, line_reference_3, line_reference_4,
         line_reference_5, line_reference_6, line_reference_7,
         line_reference_8, line_reference_9, line_reference_10,
         subledger_doc_sequence_id, subledger_doc_sequence_value, je_source,
         je_category, parent_je_header_id, creation_date, created_by,
         last_update_date, last_updated_by, last_update_login
    FROM gl_je_journal_lines_v
   WHERE set_of_books_id = 68
     AND batch_status || '' = 'P'
     AND (actual_flag = 'A')
     AND (    line_code_combination_id IN (
                 SELECT gah.detail_code_combination_id
                   FROM gl_account_hierarchies gah
                  WHERE gah.summary_code_combination_id = 1231525
                    AND gah.set_of_books_id || '' = 68)
          AND (((NVL (period_year, 0) * 1000) + NVL (period_num, 0)) >=
                                                                      2007001
              )
          AND (((NVL (period_year, 0) * 1000) + NVL (period_num, 0)) <=
                                                                      2007004
              )
         )
     AND (currency_code != 'STAT')
     AND -1 = -1
ORDER BY je_header_id, line_je_line_num