27.4.1. Procedure Analyse
analyse([max_elements,[max_memory]])
This procedure is defined in the
sql/sql_analyse.cc. This examines the
result from your query and returns an analysis of the results:
max_elements (default 256) is the
maximum number of distinct values analyse
does notice per column. This is used by
analyse to check whether the optimal data
type should be of type ENUM.
max_memory (default 8192) is the
maximum amount of memory that analyse
should allocate per column while trying to find all distinct
values.
SELECT ... FROM ... WHERE ... PROCEDURE ANALYSE([max_elements,[max_memory]])
