Jim

Both MOD.Media_Order and MO.Status have indexes.

Kevin


>>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,