Explain Plan Gives 0 Cost.
From: Charles Dye <Charles_Dye_at_corp.dialog.com>
Date: 1995/09/22
Message-ID: <43veo5$eq_at_gatekeeper.dialog.com>#1/1
Date: 1995/09/22
Message-ID: <43veo5$eq_at_gatekeeper.dialog.com>#1/1
All,
Why is this happening? V7.0.16 and V7.1.3
SQL> delete from plan_table
6 rows deleted.
SQL> explain plan
Explained.
SQL> select id, parent_id, position
ID PARENT_ID POSITION
2 /
2 for
3 select a.username, a.user_id, b.profile
4 from a, b
5 where a.user_id = b.user_id
6 and b.created < sysdate
7 and b.profile != 'DEFAULT'
8 /
2 from plan_table;
0 <<<<< Null here corresponds to Cost = 0
1 0 0
2 1 1
3 2 1
4 1 2
5 4 1
6 rows selected. Received on Fri Sep 22 1995 - 00:00:00 CEST