Hi Mike,
Its still doing FULL TABLESCAN


select count(distinct l.com_id),l.date_added, a.source
from tabs a,lis l
where
l.date_added >= to_date('01/JAN/2002','DD/MON/YYYY') and
l.date_added <= to_date('31/DEC/2002','DD/MON/YYYY') and
l.ad_id = a.ad_id
group by l.date_added,a.source 2 3 4 5 6 7
8 /

Execution Plan
----------------------------------------------------------
0 SELECT STATEMENT Optimizer=CHOOSE (Cost=602938 Card=5108360
Bytes=148142440)

1 0 SORT* (GROUP BY) (Cost=602938 Card=5108360 Bytes=148142440 :Q142066
) 003

2 1 MERGE JOIN* (Cost=559467 Card=5108360 Bytes=148142440) :Q142066
002

3 2 SORT* (JOIN) (Cost=234139 Card=5267012 Bytes=105340240 :Q142066
) 002

4 3 TABLE ACCESS* (FULL) OF 'LIS' (Cost=211905 Card= :Q142066
5267012 Bytes=105340240) 001

5 2 SORT* (JOIN) (Cost=325328 Card=7492600 Bytes=67433400) :Q142066
002

6 5 TABLE ACCESS* (FULL) OF 'TABS' (Cost=305557 Card=74926 :Q142066
00 Bytes=67433400) 000



1 PARALLEL_TO_SERIAL SELECT A1.C0,A1.C1,COUNT(DISTINCT A1.C2) FRO
M :Q142066002 A1 GROUP BY A1.C0,A1.C

2 PARALLEL_TO_PARALLEL SELECT /*+ ORDERED NO_EXPAND USE_MERGE(A2) *
/ A1.C2 C0,A2.C1 C1,A1.C1 C2 FROM :Q

3 PARALLEL_COMBINED_WITH_PARENT
4 PARALLEL_TO_PARALLEL SELECT /*+ Q142066001 NO_EXPAND ROWID(A1) */
A1."AD_ID" C0,A1."COMP_ID" C1,A1

5 PARALLEL_COMBINED_WITH_PARENT
6 PARALLEL_FROM_SERIAL