indexing

FDE interview questions tagged indexing, across every topic.

2 questions · 0 unlocked for you

Open full answer →

Open full answer →

Concepts behind "indexing"

The curriculum that explains the ideas these questions test.

🗄️ Data & SQL Engineering🔒 Premium

Query Optimization and Execution PlansWhen a customer says a query is slow, the answer lives in the execution plan, not in intuition. Reading a plan tells you whether the engine is scanning when it should seek, exploding rows in a join, or shuffling across a network, and those three causes have nothing in common except the symptom.

🤖 Retrieval & Agents🔒 Premium

Index Freshness and Staleness WindowsStaleness is a query-share number, not a corpus-share number, and the two differ by an order of magnitude or more because the documents that changed during a rebuild are the ones people are asking about. A delta index bounds the worst case to its flush interval regardless of how long the rebuild takes.

Explore the full curriculum →