Your question is Clustered vs Non-Clustered Indexes in WMS. Take a moment with it on the right.
Talk me through your thinking if you like. When you're confident, submit your answer and I'll grade it like a real screen (7/10 or better passes).
In a warehouse management system, query speed matters for tasks like locating inventory, scanning work queues, and tracing shipments. Index choice can change both read performance and how rows are physically organized.
Explain the difference between a clustered index and a non-clustered index in the context of a WMS database. In your answer, describe how each index affects physical row order, lookup speed, and maintenance cost, and when you would choose one for tables such as inventory, pick_tasks, or shipment_events.
Keep your explanation practical and database-focused. The interviewer expects you to compare storage behavior, read/write trade-offs, and the impact on common WMS access patterns such as searching by sku, location_id, or order_id.