Thank you for that - appreciated :-) Looks like it works for me. On Thu, 30 Jan 2025 at 03:14, Daniel Black <[email protected]> wrote: > > > or SET STATEMENT ef_search=X FOR SELECT .... > > https://mariadb.com/kb/en/set-statement/ > > On Wed, 29 Jan 2025 at 04:21, Vishal Rao via discuss > <[email protected]> wrote: >> >> 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 <[email protected]> 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 [email protected] >> >> >> >> -- >> "The World is a book, and those who do not travel read only a page." - >> St. Augustine. >> _______________________________________________ >> discuss mailing list -- [email protected] >> To unsubscribe send an email to [email protected]
-- "The World is a book, and those who do not travel read only a page." - St. Augustine. _______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
