What happens if you try:

> (B1) person query - slow (11-12 secs, ~2000 rows)
> select
> ca.id,cn.firstname,cn.lastname,cn.email1,cn.dateofbirth,
> ca.kind,ca.category,ca.status,cn.name
> from extendedperson ca
> join person cn on ca.personid=cn.id
> where (upper(cn.name) starting with 'S')

Select
ca.id,cn.firstname,cn.lastname,cn.email1,cn.dateofbirth, ca.kind,ca.category,ca.status,cn.name
from person cn
JOIN extendedperson ca on ca.personid=cn.id
where (upper(cn.name) starting with 'S')

Do you have an index on cn.name?


Sean