![](https://secure.gravatar.com/avatar/39b623a1559cf9c69ac3d9d4fb44e7fe.jpg?s=120&d=mm&r=g)
28 Jan
2025
28 Jan
'25
4:59 p.m.
Hi, Vishal, There is no way to set it per table, because ef_search is not a property of the index, it's a property of the search. It affects how you do SELECT, but it does not affect the index or INSERT in any way. On Jan 28, Vishal Rao via discuss wrote:
Hello!
The mariadb vector 11.7.1-rc release has the option to specify default_m in the CREATE TABLE statement VECTOR specification by including "M=x" option but apparently no option to specify the ef_search value.
Is there any intent to add this option to the CREATE TABLE statement on the roadmap - I hope this is a valid way to set the ef_search value per table?
Regards, Sergei Chief Architect, MariaDB Server and security@mariadb.org