Hello

I do a simply outer join on two tables:

select
p.personid, p.lastname,p.middlename, p.prename
from
person p left outer join
employee e on (e.personid=p.personid)

This makes a full table scan as i see in performance
analysis on table person.
If i simply add a nonsense where clause like this, it works
well:

where p.personid > 0

I don't understand this behavior. Can you explain me this
please?

Thanks

Francois