Scribd Logo
Upload

Welcome to Scribd!

  • 116 views

    Difference Between Simple View Complex View and Mat View

    Uploaded by

    Sangameshpatil
    A simple view selects data from one table while a complex view selects from multiple tables. DML can be performed on simple views but not always on complex views. Views do not consume storage space whereas materialized views store the results of a query, allowing for improved report performance but using additional storage. Materialized views reference model query subjects in the database and updates made to a materialized view will also update the referenced query subject.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd

    Difference Between Simple View Complex View and Mat View

    Uploaded by

    Sangameshpatil
    116 views1 page
    A simple view selects data from one table while a complex view selects from multiple tables. DML can be performed on simple views but not always on complex views. Views do not consume storage space whereas materialized views store the results of a query, allowing for improved report performance but using additional storage. Materialized views reference model query subjects in the database and updates made to a materialized view will also update the referenced query subject.

    Original Description:

    Simple View Complex View and Mat View

    Copyright

    © © All Rights Reserved

    Available Formats

    DOC, PDF, TXT or read online from Scribd

    Did you find this document useful?

    Is this content inappropriate?

    A simple view selects data from one table while a complex view selects from multiple tables. DML can be performed on simple views but not always on complex views. Views do not consume storage space whereas materialized views store the results of a query, allowing for improved report performance but using additional storage. Materialized views reference model query subjects in the database and updates made to a materialized view will also update the referenced query subject.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    116 views1 page

    Difference Between Simple View Complex View and Mat View

    Uploaded by

    Sangameshpatil
    A simple view selects data from one table while a complex view selects from multiple tables. DML can be performed on simple views but not always on complex views. Views do not consume storage space whereas materialized views store the results of a query, allowing for improved report performance but using additional storage. Materialized views reference model query subjects in the database and updates made to a materialized view will also update the referenced query subject.

    Copyright:

    © All Rights Reserved
    Download as DOC, PDF, TXT or read online from Scribd
    Download as doc, pdf, or txt
    of 1

    Difference between simple view and complex view?

    Here are few differences between simple and complex views.


    A Simple view selects data from one table. A Complex view selects
    records from one or more tables.
    You can perform DML through Simple views but you cannot
    always perform DML through Complex views.
    Difference between simple view and materialized view?
    View does not consume space and materialized view consume
    space
    Materialized view
    A materialized view contains the results of a query from the
    target model. It can be used to summarize, pre-compute, replicate,
    and distribute data. Using a materialized view can improve the
    performance of running reports.
    A materialized view references model query subjects in the database
    layer in the target model. If you modify the materialized view, the
    model query subject is automatically updated. If you delete a
    materialized view, the model query subject is also deleted.
    You can store materialized views in any folder in the target model.

    You might also like