Re: select counts versus insert/select counts

It might be worth looking at the execution plans. Because of an oddity in costing, the plan for   select ...
may differ from the plan for
  insert into ... select ...

The problem, of course, is knowing which plan is giving the correct answer. If the plans are different, you could try hinting the "alternative" plan to see what happens.

Regards
Jonathan Lewis
http://jonathanlewis.wordpress.com
http://www.jlcomp.demon.co.uk

--
http://www.freelists.org/webpage/oracle-l