"Robert DiFalco" <[EMAIL PROTECTED]> wrote on 02/27/2006 04:53:06 PM:
> Is there a command to regenerating the selectivity statistics of indices > with MySQL? Or does MySQL not have a cost based optimizer and this would > make no difference? > > R. MySQL uses a cost-based optimizer http://dev.mysql.com/doc/refman/4.1/en/query-speed.html and the command you are looking for is "ANALYZE TABLE" http://dev.mysql.com/doc/refman/4.1/en/analyze-table.html Shawn Green Database Administrator Unimin Corporation - Spruce Pine