建表时指定为bTree的索引

CREATE TABLE `supplier_activity` (
  `id` bigint(20) NOT NULL AUTO_INCREMENT COMMENT '主键id',
  `activity_id` bigint(20) DEFAULT NULL COMMENT '所属活动id',
  PRIMARY KEY (`id`),
  KEY `idx_activity_id` (`activity_id`) USING BTREE,
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='xxx ';

KEY `idx_activity_id` (`activity_id`) USING BTREE,

是在activity_id上建立了BTREE的索引