🤯 constrain on an unindexed calc

For a subset of a million records requiring further constraint, it's quicker to constrain on an unindexed calc field. Confining on an indexed field would involve processing the million-record index.

(cued up 35:45)

6 Likes

Great excerpt! Thank you, @rivet.

Very interesting!