References vs Denormalized Fields: Modelling for AI Use Cases
Your agent gets asked for "products with waterproofing under $150 that are in stock." The vector search returns things that read like the question but ignore the price ceiling, skip the stock check, and never touch the feature.