Results 1 to 4 of 4
  1. #1
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170

    Unanswered: Materialized Query Tables

    What is the difference bertween a Summary Table of V7 and Materialized Query Tables of V8.


    Thanks
    Prasad Koganti

  2. #2
    Join Date
    May 2003
    Location
    USA
    Posts
    5,737
    From the version 8 SQL Reference vol 2:

    "A materialized query table whose fullselect contains a GROUP BY
    clause is summarizing data from the tables referenced in the fullselect.
    Such a materialized query table is also known as a summary table. A
    summary table is a specialized type of materialized query table."

  3. #3
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    Thanks For the info.
    I believe you can do MQTs and ASTs in V7 Summary tables.
    Can some body correct me if iam wrong

  4. #4
    Join Date
    Jul 2002
    Location
    ATL
    Posts
    170
    Any more ideas ????

Posting Permissions

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