Cost=BLANK on query plan display

From: Jason Selby <jselby_at_cams.co.uk>
Date: Fri, 01 May 1998 15:51:49 +0100
Message-ID: <3549E185.ABCB220B@cams.co.uk>

Hi

When I build a query plan as follows

explain plan set statement_id = 'cav032' for SELECT
term_key||'|'||term_id||'|'||key_type||'|'||rank||'|'||medical_type FROM cav_mrkey m
WHERE NOT EXISTS (
  SELECT * FROM cav_keys k
  WHERE m.term_key = k.term_key
  AND m.term_id = k.term_id
  AND m.key_type = k.key_type);

And display it in SQL*PLUS like so

select lpad(' ',2*(level-1))||operation||' '||options||' '|| object_name||' '||decode(id,0,'Cost = '||position) "Query Plan" from plan_table
start with id = 0 and statement_id = 'cav032' connect by prior id = parent_id and statement_id = 'cav032';

I get

Query Plan

---

SELECT STATEMENT Cost =
  FILTER
    TABLE ACCESS FULL CAV_MRKEY
    INDEX RANGE SCAN I_CAV_KEYS_TERMIDTYPE Why is 'Cost=' always a blank figure is there another way of getting the overall cost of a query

TIA Jason Received on Fri May 01 1998 - 09:51:49 CDT