• Home
• us.fatehi
• schemacrawler-testdb
• 16.24.2
• source code
• 32_views_materialized_C.sql

×

Project download

Many resources are needed to download a project. Please understand that we have to compensate our server costs. Thank you in advance.
Project price only 1 $

You can buy this project and download/modify it how often you want.

db.books.32_views_materialized_C.sql Maven / Gradle / Ivy

-- Materialized views
-- IBM DB2 materialized query table (MQT)
CREATE TABLE AuthorsCountries
(
  Id,
  FirstName,
  LastName,
  Country
)
AS
(
  SELECT
    Id,
    FirstName,
    LastName,
    Country
  FROM
    Authors
)
DATA INITIALLY DEFERRED
REFRESH DEFERRED
MAINTAINED BY SYSTEM
ENABLE QUERY OPTIMIZATION
;

SET INTEGRITY FOR AUTHORSCOUNTRIES ALL IMMEDIATE UNCHECKED;