MySQL ODBC Connector - Updating Index Statistics

Author

Updating Index Statistics

Robert DiFalco

2006-02-28, 8:28 pm

------ _=_NextPart_001_01C6
3BE8.3116FFF3
Content-Type: text/plain;
charset="us-ascii"
Content-Transfer-Encoding: quoted-printable

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?
=20
R.

------ _=_NextPart_001_01C6
3BE8.3116FFF3--

SGreen@unimin.com

2006-02-28, 8:28 pm

--=_alternative 0078304085257122_=
Content-Type: text/plain; charset="US-ASCII"

"Robert DiFalco" <rdifalco@tripwire.com> 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...lyze-table.html

Shawn Green
Database Administrator
Unimin Corporation - Spruce Pine
--=_alternative 0078304085257122_=--

Sponsored Links