That did it. It takes almost 2 minutes for the thing to run, but at least it runs now. Thanks!
On 3/30/06, Robert Munn <[EMAIL PROTECTED]> wrote: > > Add an index to videos.CatID. That is almost certainly a problem, given > that > you are joining that table to the huge table. I might also add an index to > catagories.Cat because you are ordering by that field, although that > operation should not be expensive in the select. > ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:5:202342 Archives: http://www.houseoffusion.com/cf_lists/threads.cfm/5 Subscription: http://www.houseoffusion.com/lists.cfm/link=s:5 Unsubscribe: http://www.houseoffusion.com/cf_lists/unsubscribe.cfm?user=11502.10531.5 Donations & Support: http://www.houseoffusion.com/tiny.cfm/54
