Explain Plan Question

Do the number of rows in tables change the output for Explain Plan (tkprof) on the same machine? The Optimizer used is Rule based.

Let's say I run a query:

SELECT /*+ RULE */ COUNT(*)

FROM       tableA a, tableB b
WHERE     a.id = b.dept_id (+);

First time let's say there are 0 rows in each of these tables. Now I run tkprof and get the results .

Second time let's say there are 1000+ rows in both of these tables. Will the results of explain plan will be same as in previous case ?

Thanks

• Zoom