Dan Crea wrote:
<<
...
SELECT OutboundMedia.MKey, OutboundMedia.DestinationDomain
FROM OutboundMedia, MediaItem
WHERE MediaItem.IState = 5
GROUP BY OutboundMedia.MKey, OutboundMedia.DestinationDomain
...

>>

Is there some relation between the two tables that you want to use?
A join ot something?

The NATURAL in the plan is not usually a sign of something being
fast. Maybe it scans all of the OUTBOUNDMEDIA table for each occurance of
a record in MEDIAITEM with ISTATE=5. Does the output look right?


Regards,
Aage J.