page61
43
MAX_CLUSTER_COUNT = 1
SCALING_POLICY = 'STANDARD'
INITIALLY_SUSPENDED = TRUE;
CREATE OR REPLACE WAREHOUSE IDENTIFIER ( $tpc_warehouse_M ) WITH
WAREHOUSE_SIZE = 'MEDIUM'
AUTO_SUSPEND = 60
AUTO_RESUME = TRUE
MIN_CLUSTER_COUNT = 1
MAX_CLUSTER_COUNT = 1
SCALING_POLICY = 'STANDARD'
INITIALLY_SUSPENDED = TRUE;
CREATE OR REPLACE WAREHOUSE IDENTIFIER ( $tpc_warehouse_L ) WITH
WAREHOUSE_SIZE = 'LARGE'
AUTO_SUSPEND = 60
AUTO_RESUME = TRUE
MIN_CLUSTER_COUNT = 1
MAX_CLUSTER_COUNT = 1
SCALING_POLICY = 'STANDARD'
INITIALLY_SUSPENDED = TRUE;
CREATE OR REPLACE WAREHOUSE IDENTIFIER ( $tpc_warehouse_XL ) WITH
WAREHOUSE_SIZE = 'X-LARGE'
AUTO_SUSPEND = 60
AUTO_RESUME = TRUE
MIN_CLUSTER_COUNT = 1
MAX_CLUSTER_COUNT = 1
SCALING_POLICY = 'STANDARD'
INITIALLY_SUSPENDED = TRUE;
You can use the securityadmin role to create roles and add object entitlements to
roles. You can first create a new role called
tpc_owner_role
.
USE ROLE securityadmin;
CREATE OR REPLACE ROLE IDENTIFIER ( $tpc_owner_role );
ChapTer 3
The Query profiler