read here.. http://download.oracle.com/docs/cd/B19306_01/server.102/b14211/advisor.htm
On Nov 20, 2007 7:17 PM, Moch Firman N <[EMAIL PROTECTED]> wrote: > Hi bro,, > > What is The SQL Access Adviser ? ** sorry ** > Would u explain me...? > > > On Nov 20, 2007 4:51 PM, Andi Afandi <[EMAIL > PROTECTED]<andi.afandi%40yahoo.com>> > wrote: > > > Dear all friends, > > I run SQL Access Advisor under oracle 10g. > > As a result, it recommends to create a materialized view with a bit > > improvement as suggestion. > > If i implement those recommendation; create a materialized view, is it > > really improve > > the performance of query....? > > What is exactly materialized view...??? > > Honestly, I don't really understand what it is..., and never implement > > those recommendation, generated by SQL Access Advisor. > > As information, I'm trying to Tune the indexes in our Oracle DB. > > Please share with me if you guys have softcopy of Index Tuning workshop > > from oracle university..., > > because i feel can not absorb the knowledge from the manual of oracle > > downloaded document. > > Please.., please..., bitte..., bitte.... > > (feel free untuk menjawab dalam bahasa indonesia, saya hanya membiasakan > > in english.) > > > > Vielen Dank > > > > Afandi > > > > --------------------------------- > > Be a better sports nut! Let your teams follow you with Yahoo Mobile. Try > > it now. > > > > [Non-text portions of this message have been removed] > > > > > > > > [Non-text portions of this message have been removed] > > > [Non-text portions of this message have been removed]

