Search code examples
mysqlb-treedatabase-indexes

Advantage of BTREE?


I create indexes without the USING BTREE clause. Is there any advantage of using BTREE index?

CREATE INDEX `SomeName` USING BTREE ON `tbl_Name`(`column_name`);

Solution

  • BTREE is the default index method. You may safely omit it.