SQL & PL/SQL

Hi Gurus,

I have a view 'view_a' and a table 'table_a'

view_a has count of 100 rows.Now when I left outer join that view with a 'table_a',I expect all 100 rows.

However I am getting more than 100 rows.Is that ever possible?

Also even to analyse these situations, how do I move forward?

Because these are really high volumn view's and takes longer time to execute.

Select  count(*) from view_a ,view_b

          where view_a.col1 = view_b.col1(+)

          and view_a.col2 = view_b.col2(+);

Thanks