Indexing & Optimization

Create an index via CLI:

aingdb create-index --path ./app.adb --name idx_users_name --table users --columns "name"

Or via SQL:

CREATE INDEX idx_users_name ON users(name);

Run stats collection:

aingdb analyze --path ./app.adb

Tips:

• Keep data local and compact periodically (aingdb compact)
• Choose vector for embedding columns, text for FTS, json for shapes
• Use ttl to auto‑expire data you don't need