Maybe you could mention what indexes are present
on the underlying tables (animals, pedigree2, etc), and their
cardinality, and
the query-optimisation level you are using, and whether
the statistics are up to date, and what the access
plan shows?