DBAsupport.com Forums - Powered by vBulletin
Results 1 to 2 of 2

Thread: Inline Views Vs Materialized Views

  1. 06-13-2003, 09:13 AM #1
    zzz
    zzz is offline Junior Member
    Join Date
    Sep 2002
    Posts
    13

    Inline Views Vs Materialized Views

    Hi all,
    I had the following doubts
    1. What is the difference(INTERMS OF PERFORMANCE) between using INLINE VIEW in an SQL statement and putting the query of the INLINE VIEW in MATERIALIZED VIEW and then using MATERIALIZED VIEW in the SQL statement.
    2. What is the difference(INTERMS OF PERFORMANCE) between using INLINE VIEW in an SQL statement and using WITH clause in the SQL statement using 9i.,


    Please Clarify this .........

    Thanks in Advance.........

    regards
    ZZZ
    Reply With Quote Reply With Quote
  2. 06-18-2003, 11:08 AM #2
    akskumar
    akskumar is offline Junior Member
    Join Date
    Jun 2002
    Posts
    8
    1.Putting the query in a materialized view and then using the materialized view would be faster assuming that the number of rows would be lesser in the materialized view than in the actual table on which the inline query would be based.
    2.None at all

    hth
    Reply With Quote Reply With Quote
« Previous Thread | Next Thread »

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  

Forum Rules

Click Here to Expand Forum to Full Width