If this is your first visit, be sure to
check out the FAQ by clicking the
link above. You may have to register
before you can post: click the register link above to proceed. To start viewing messages,
select the forum that you want to visit from the selection below.

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