A slow query is not always just a “bad query.” Sometimes the query plan looks reasonable, the index is being used, and […]
Read More
Why HNSW Indexes Are So Fast in YugabyteDB
Vector search gets expensive fast. Without an index, every query has to compare your search embedding against every row in the table. […]
Read MoreNo Primary Key in YSQL? YugabyteDB Still Creates One
At first glance, YugabyteDB behaves just like PostgreSQL. You can create a table without a primary key: CREATE TABLE no_pk(id INT); No […]
Read MoreHow to Do a Simple Index Consistency Check
Indexes are supposed to accurately reflect what’s in the base table. Newer versions of YugabyteDB include yb_index_check() to validate this, but if […]
Read More