I see! So if I understand correctly I can just set the ef_search var
as a session value before executing a SELECT which should suffice to
take effect? Thank you!

On Tue, 28 Jan 2025 at 22:29, Sergei Golubchik <serg@mariadb.org> wrote:
>
> 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



--
"The World is a book, and those who do not travel read only a page." -
St. Augustine.
_______________________________________________
discuss mailing list -- discuss@lists.mariadb.org
To unsubscribe send an email to discuss-leave@lists.mariadb.org