TONUMBER() type-conversion function performance issues

TO_NUMBER() also works with upcoming 4.5 GA

insert into default values(“v001”,{“user”:“123456789”});
CREATE INDEX `user-session-idx` ON `default`(TO_NUMBER(`user`));
SELECT meta().id FROM `default` WHERE TO_NUMBER(`user`)=123456789;

1 Like