.db (data rows) Idx Role: B-tree structure for rapid WHERE lookups. Why critical: Without the .idx , a SELECT * FROM users WHERE last_name = 'Smith' requires a full table scan (O(n)). With the index, it becomes O(log n). The .idx contains sorted keys and physical row pointers (ROWIDs).