Copyright (C) 2000-2012 |
GNU Info (mysql.info)procedure analyseProcedure 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' will notice per column. This is used by `analyse' to check if the optimal column type should be of type `ENUM'. * `max memory' (default 8192) is the maximum memory `analyse' should allocate per column while trying to find all distinct values. SELECT ... FROM ... WHERE ... PROCEDURE ANALYSE([max elements,[max memory]]) automatically generated by info2www version 1.2.2.9 |