Replaced two slow queries using cc_users with their faster equivalent usingparties and users. Makes a huge difference on Oracle when there are many,many users (49,000 in this case). And yes, I checked, the original queriesused indexes galore, Oracle was doing as well as can be expected.