Results 1 to 3 of 3
  1. #1
    Join Date
    Dec 2003
    Location
    U.S.
    Posts
    3

    Unanswered: Materialized views

    Hi,
    Can one table have two materialized views?
    1. Count(*)
    2. Freq of one column (select column_name, count(*) from table_name
    group by column_name

    And approximately how many rows table can have materialized views?

    Thanks.

  2. #2
    Join Date
    Dec 2003
    Location
    Oklahoma, USA
    Posts
    354
    Yes, you can have more than one materialized view on a table. You can even have the different materialized views have the same query, just using different names, and it will work as well.

    As to the number of rows possible using materialized view, I don't think there is a limit just because it is a materialized view. The only limits posed (I believe, correct me if I'm wrong) are that of space.... run out of space to store the table, run out of rows you can add. Remember, a materialized view has similar properties to a regular table.

    Hope this helps.

    JoeB

  3. #3
    Join Date
    Dec 2003
    Location
    U.S.
    Posts
    3

    Thank u

    Thanks for the reply.

Posting Permissions

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