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.
On 3/30/06, Todd Ashworth <[EMAIL PROTECTED]> wrote: > > > hmm looks like I was wrong about a few of those indexes. > > table: catagories - 140 records > Cat varchar(21) not indexed foreign key > CatID integer indexed table: videos - 21,304 records > VideoID integer indexed primary key > MovieTitle varchar(75) indexed > MC integer not indexed > CatID integer not indexed > > -- --------------- Robert Munn www.funkymojo.com ~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~~| Message: http://www.houseoffusion.com/lists.cfm/link=i:5:202336 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
