On Fri, Oct 03, 2003 at 04:23:56PM -0400, Matt Babineau wrote: > now the query isn't finishing executing and its killing my cpu... > > any idea how to rebuild the index on a table? > > or how to get out of this mess?
Drop and re-add the index? Jeremy -- Jeremy D. Zawodny | Perl, Web, MySQL, Linux Magazine, Yahoo! <[EMAIL PROTECTED]> | http://jeremy.zawodny.com/ MySQL 4.0.15-Yahoo-SMP: up 20 days, processed 721,180,492 queries (417/sec. avg) -- MySQL General Mailing List For list archives: http://lists.mysql.com/mysql To unsubscribe: http://lists.mysql.com/[EMAIL PROTECTED]
