Dan,

> For example:
> SELECT OutboundMedia.MKey, OutboundMedia.DestinationDomain
> FROM OutboundMedia, MediaItem
> WHERE MediaItem.IState = 5
> GROUP BY OutboundMedia.MKey, OutboundMedia.DestinationDomain

...

> That's right this query took 7 minutes to execute and during this
> time ibserver.exe consumes nearly 100%cpu time. What is going on
> here??

You haven't told the engine what the relationship is between
OutboundMedia and MediaItem

Your should restart the query as:


SELECT OutboundMedia.MKey, OutboundMedia.DestinationDomain
FROM OutboundMedia
join MediaItem on MediaItem.xxx = OutboundMedia.yyyy
WHERE MediaItem.IState = 5
GROUP BY OutboundMedia.MKey, OutboundMedia.DestinationDomain

--
Sean Leyne

Support Firebird, join FirebirdSQL Foundation today!
http://www.FirebirdSQL.org/foundation