>I'm still working on this one. This query is a pared down version of
>what I actually need. I killed this after 5 minutes.
>
>There is an index on media_order.Id
>
>

>
>use euro_temp
>
>select mo.Document AS DocId,
>       mo.id AS MoId,
>       mod.Id AS ModId,
>       mo.show_title AS ShowId,
>       mo.order_rate,
>       mo.program_name,
>       mo.order_qty,
>       mod.actual_air_date,
>       mod.actual_air_time
>  FROM Media_Order mo
>  JOIN Media_Order_Detail mod ON mod.Media_Order = mo.id
>  WHERE mo.status = 'ACTIVE'
>

How about an index on Media_Order_Detail.Media_Order. This is probably more important than the index on Media_Order.ID.

Also, depending on the mix of status records, an index on Media_Order.Status might either help or hurt.

Regards,