You can generate the SQL to create relational views and materialized
query tables (MQTs) from SELECT and FULLSELECT statements in physical data
models in data design projects.
Generating relational views from SQL statements
You can use SELECT statements and FULLSELECT statements in a physical data model of a data design project to generate relational views in the physical data model.
Generating materialized query tables from SQL statements
You can use SELECT statements and FULLSELECT statements in a physical data model of a data design project to generate materialized query tables (MQTs) in the physical data model.