WL#2252: Automatic co-location of related rows
Affects: Benchmarks-3.0 — Status: Un-Assigned — Priority: Medium
Typical setup: Holder holder_id int autoincrement primary key holder_name varchar(255) Account account_id int autoincrement primary key holder_id int REFERENCES holder(holder_id) I.e. each account has a holder. The idea is to change to schema slightly into Account account_id identity primary key holder_id int REFERENCES holder(holder_id) Idea: account_id is a generated value that will hash into same fragment as holder_id
Copyright (c) 2000, 2015, Oracle Corporation and/or its affiliates. All rights reserved.