Note : If the tables are already created, it will indicate so on the console. Proceed to the step no. 3 in this case
Prerequisites
Make sure a multi-partition processing instance and the designdb
database are created before proceeding. Please refer to the Design Overview section for detailed instructions.
The prerequisite tables are created in order to run the query against tables before and after compression and
compare the size savings as well as query performance improvement
Operation
- Click on the action button on the Action panel
- It creates tables enabled for multidimensional clustering and populates them with data.
Note
- For the syntax of the above, please refer to the following in this workshop:
- Multidimensional Clustering (MDC) - page 3