vitess.io/vitess@v0.16.2/go/vt/vtexplain/testdata/gen4-queries.sql (about)

     1  
     2  select * from user_region where regionId = 4611686018427387904 and userId = 100 /* exact shard */;
     3  select * from user_region where regionId = 4611686018427387904 /* subshard */;
     4  select * from user_region where regionId in (4611686018427387903, 4611686018427387904) /* subshard */;
     5  select * from user_region where userId = 100 /* scatter, needs prefix columns for subshard routing */;