<blockquote> But note the price of acs.magic_object_id: "evils of
PL/SQL" (my broken vinyl record) and not telling the
database what I know.
</blockquote>
Hi Dirk! What if you tried the following in your query above:
and m.party_id = (select acs.magic_object_id('the_public'))
I seem to remember optimizing a Postgres query by doing something similar, the idea being that the subselect only runs once. BTW, does Oracle support the notion of defining acs.magic_object_id() as immutable or stable?
