oracle组合索引最左原则,复合索引&最左原则 -- 实战

建表语句：

CREATE TABLE `t_user` (

`id` BIGINT(20) NOT NULL AUTO_INCREMENT,

`bu_id` INT(20) NOT NULL,

`name` VARCHAR(255) NOT NULL,

`age` INT(11) NOT NULL,

`sex` VARCHAR(255) NULL DEFAULT NULL,

PRIMARY KEY (`id`),

INDEX `index_uid_name_age` (`bu_id`, `name`, `age`)

)

COLLATE='utf8_general_ci'

ENGINE=InnoDB

AUTO_INCREMENT=22014

;

批量插入数据：

CREATE PROCEDURE batch_insert()

BEGIN

DECLARE a INT DEFAULT 1;

WHILE (a <= 10000) DO

SET a = a + 1;

insert into t_user set name='name2', age=a, bu_id=a+5;

END WHILE;

COMMIT;

END;

CALL batch_insert();

**Explain SQL： **