9 Query and DML Processing

On a sharded database, queries and DML can be routed to the shards for processing with or without a sharding key. If a key is provided by the application a database request is routed directly to the shards, but if no key is provided the request is processed by the shard catalog, and then directed to the necessary shards for processing.