Execution plan Question

hi !

i have made 2 execution plans for equivalent queries, and my problem is, which one to use.
here are the reduced plans:

no 1 is:
selct stmt

   filter cost 1

      table access tab2 FULL cost 1
      table access tab1 FULL cost 2

no 2 is:
select stmt

   nested loops cost 1

      table access full tab1 cost 1
      table access by rowid tab2 cost 2
          index range scan tab2_pk cost 1

of course the first approach is to say that 2 full scans are much slower , but the filter operation is much more cheaper (linear i think) then the nested loop in the 2nd plan.

table tab1 has max. 20-30 records, tab2 about 2000 - 4000 records.

anybody ... ?

thanks a lot !

bye, ulli

• Ulli Hertlein
• EMAIL: hertlein_at_gbraun-ems.de
• URL: http://WWW.ulli.hertlein.home.pages.de

  ---