Slide 21
Slide 21 text
SHARDINGADVISOR_CONFIGURATIONS表 - どの表をSHARDED/DUPLICATEDにするか
シャーディング・アドバイザ実⾏例
Copyright © 2021, Oracle and/or its affiliates
21
SELECT rank, tableName as tname, tabletype as type,
tablelevel as tlevel, parent, shardby as shardBy,
shardingorreferencecols as cols, unenforceableconstraints,
sizeoftable
FROM SHARDINGADVISOR_CONFIGURATIONS
ORDER BY rank, tlevel, tname, parent;
RANK TNAME TYP TLEVEL PARENT SHARDBY COLS
---------- ------------------------------ --- ---------- -------------------- ---------- -------------------------
1 SOE.CUSTOMERS S 1 HASH CUSTOMER_ID
1 SOE.ADDRESSES S 2 SOE.CUSTOMERS REFERENCE ADD_CUST_FK
1 SOE.CARD_DETAILS D NONE
1 SOE.INVENTORIES D NONE
1 SOE.LOGON D NONE
1 SOE.ORDERENTRY_METADATA D NONE
1 SOE.ORDERS D NONE
1 SOE.ORDER_ITEMS D NONE
1 SOE.PRODUCT_DESCRIPTIONS D NONE
1 SOE.PRODUCT_INFORMATION D NONE
1 SOE.WAREHOUSES D NONE
RANK TNAME TYP TLEVEL PARENT SHARDBY COLS
---------- ------------------------------ --- ---------- -------------------- ---------- -------------------------
2 SOE.CUSTOMERS S 1 HASH CUSTOMER_ID
2 SOE.ORDERS S 2 SOE.CUSTOMERS REFERENCE ORDERS_CUSTOMER_ID_FK
2 SOE.ADDRESSES D NONE
2 SOE.CARD_DETAILS D NONE
2 SOE.INVENTORIES D NONE
2 SOE.LOGON D NONE
2 SOE.ORDERENTRY_METADATA D NONE
2 SOE.ORDER_ITEMS D NONE
2 SOE.PRODUCT_DESCRIPTIONS D NONE
2 SOE.PRODUCT_INFORMATION D NONE
2 SOE.WAREHOUSES D NONE
RANK TNAME TYP TLEVEL PARENT SHARDBY COLS
---------- ------------------------------ --- ---------- -------------------- ---------- -------------------------
3 SOE.CUSTOMERS S 1 HASH CUSTOMER_ID
3 SOE.ADDRESSES S 2 SOE.CUSTOMERS REFERENCE ADD_CUST_FK
3 SOE.ORDERS S 2 SOE.CUSTOMERS REFERENCE ORDERS_CUSTOMER_ID_FK
3 SOE.CARD_DETAILS D NONE
3 SOE.INVENTORIES D NONE
3 SOE.LOGON D NONE
3 SOE.ORDERENTRY_METADATA D NONE
3 SOE.ORDER_ITEMS D NONE
3 SOE.PRODUCT_DESCRIPTIONS D NONE
3 SOE.PRODUCT_INFORMATION D NONE
3 SOE.WAREHOUSES D NONE
SHARDED/DUPLICATED
SHARDED表の階層
SHARDED表の親表
パーティショニングの種類 パーティショニング列
候補