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] >
_______________________________________________ discuss mailing list -- [email protected] To unsubscribe send an email to [email protected]
