I just realized that in mysql “USE INDEX (i)” is a great idea especially if your table has multiple indexes. Mysql 5.0 was completely ignoring the index and our queries were awfully slow. Took a bid of maneuvering to figure this one out hope it helps!.