What plan do you get if you just use cr_revisions instead of the phb_spanx view (and doing SELECT * to avoid all those phb_span column reference)?
