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


Thanks
Prasad Koganti

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."

Thanks For the info.
I believe you can do MQTs and ASTs in V7 Summary tables.
Can some body correct me if iam wrong

Any more ideas ????