Ultimate

X_QUERY_UNINDEXED

Means

a statement no index can serve: the planner can only scan the table

Typical cause

a where clause on columns no index leads with, or a read with no condition at all, seen in the exercise pass

Fix

x db gen "index <table> <columns>" — after indexes: [{ on: ['<orgId>', '<column>'] }] in entity('<entity>'); or scan: '<why it stays small>' in that entity(); or expectedSeqScan('<why>', fn) around a read that compares no column

Listed under Testing

This page as markdown