Results 1 to 3 of 3
  1. #1
    Join Date
    Jun 2009
    Location
    islamabad
    Posts
    9

    Thumbs up Unanswered: MVIEWS are very slow,how i can tune the mviews

    i am using 10g ,i have some large mviews but when i query then it give me result very slow but same query i run on master table it give me result fast, so kindly guide me how i tune the mviews/snapshot that my query give me result fast as like master tables.
    this is very urgent for me

    regards
    shazia

  2. #2
    Join Date
    Jan 2004
    Location
    Croatia, Europe
    Posts
    4,094
    Provided Answers: 4
    Do indexes exist on a materialized view? If not, try to create the same ones as you have on a master table and run the query again.

  3. #3
    Join Date
    Nov 2003
    Posts
    2,935
    Provided Answers: 12
    You tune mviews just the way you tune regular tables.
    After all they are regular tables.

Posting Permissions

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