Most of the time I reach for a vector database, the first version is slow in a way that is easy to miss. The queries return the right rows, the demo works, and then the table grows and every search starts scanning the whole dataset. Indexing is what fixes that, and LanceDB gives you more than one kind of index because "search" in a real application is rarely just vector similarity. You usually filter by price, by category, or by some text field at the same time.
This guide walks through the indexes LanceDB exposes in its Python SDK, with runnable code and a short note on when each one earns its place. I have spent a fair amount of time in LanceDB's index layer as a contributor, so the aim here is to be practical rather than exhaustive.
Setting up a table
Install the package and create a small table to work with. LanceDB stores data on disk and infers the schema from the first batch of rows, so you can start with plain dictionaries.
import lancedb
db = lancedb .…