Chapter 3 Building Physical Diagrams

Defining a view as a query table

You define a view as a query table by selecting the query table or materialized view type in the view property sheet.

The query creation order of DB2 summary table is of type:

create summary table VIEW_1 as
...

The query creation order of DB2 materialized query table is of type:

create table VIEW_1 as
...

The query creation order of Oracle materialized view is of type:

create materialized view VIEW_1 as
...

The query creation order of an Oracle snapshot is of type:

create snapshot VIEW_1 as
...

If you change the DBMS of a model containing query tables, these are converted into regular views.

Physical options

Query tables support physical options. When you select a query table type in the view property sheet, the Options tab automatically appears to let you define physical options for view generation.

Copyright (C) 2005. Sybase Inc. All rights reserved.