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

Thread: Need help on the materialized views

  1. #1
    Join Date
    Oct 2000
    Posts
    250
    Hello Everyone,
    I have few materialized views which are consists of few huge tables joined together. When I create the mview it takes me forever. My number of rows in a table is about 30 million records but of course I will take the whole number of records into the mview as I have the where condition in my table selection.

    Anyone can help me on this will be very much appreciated.
    Any bright idea ?
    Thanks

  2. #2
    Join Date
    Oct 2000
    Posts
    250
    Will it help on if I create some indexes before create the mviews ?
    I have another idea is to run the script to insert into a temporary table and create the mview based on the temporay table created but the problem is am I going to perform query rewrite into this mviews in the future.

    Thanks

  3. #3
    Join Date
    Jun 2000
    Location
    Madrid, Spain
    Posts
    7,447
    I dont understand why creating a temp table would solve your problem since materialized view itself is a table already
    have you checked waits and explain plan when you are creating the materialized view?

  4. #4
    Join Date
    Oct 2000
    Posts
    250
    Ya, That is my concern on creating temp table I have no ways to refresh in future. But at the moment the creation Mviews really slow what is u suggestions on this ?

    Thanks

Posting Permissions

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


Click Here to Expand Forum to Full Width