Indexing your vectors

You do not have to create indexes on your lance tables in order to perform nearest-neighbor searches on them. However, these searches will perform significantly better with indexes.

Indexes on these tables are static. However, vectors inserted after the index is built can still be searched. The search will automatically use the index and then pivot to a brute-force search on the unindexed data.

You do not need to drop an index on a lance table in order to rebuild it. Simply create the index again and the original index will automatically be dropped.

See the lvector_create_index() UDR for more information