window functions, 2428 PARTITION BY LIST COLUMNS, 4667 PARTITION BY RANGE COLUMNS, 4667 partition management, 4686 partition pruning, 4705 partitioning, 4655 advantages, 4658 and dates, 4659 and foreign keys, 4716 and FULLTEXT indexes, 4717 and replication, 3669, 3672 and SQL mode, 3672, 4714 and subqueries, 4717 and temporary tables, 4717, 4720 by hash, 4675 by key, 4678 by linear hash, 4677 by linear key, 4680 by list, 4665 by range, 4661 COLUMNS, 4667 concepts, 4656 data type of partitioning key, 4717 enabling, 4655 functions allowed in partitioning expressions, 4725 index prefixes, 4718 keys, 4658 limitations, 4714 operators not permitted in partitioning expressions, 4714 operators supported in partitioning expressions, 4714 optimization, 4703, 4705 partitioning expression, 4658 resources, 4656 storage engines (limitations), 4724 subpartitioning, 4719 support, 4655 support in NDB Cluster, 3967 tables, 4655 types, 4659 window functions, 2428 Partitioning maximum number of partitions, 4716 partitioning information statements, 4703 partitioning keys and primary keys, 4720 partitioning keys and unique keys, 4720 partitions adding and dropping, 4686 analyzing, 4701 checking, 4701 managing, 4686 modifying, 4686 optimizing, 4701 repairing, 4701 splitting and merging, 4686 5502