beberapa keyword tuning query, kalo ngerti how it works sampai tweaking akan maknyus ngoprek query dodol :) al selectivity cardinality statistik access path join metod join permutation histogram outline hint dkk
jika ditanya gimana caranya tanpa query nya sendiri kayak apa, akan terlalu ngawang2. Krn data distribution dan data skew memegang faktor penting, sehingga query tuning akan unik case by casenya On 8/28/10, Moch Firman N <[email protected]> wrote: > Note : Jangan berasumsi Full Table Scan gak bagus > > 2010/8/16 Sandi Jatmika <[email protected]> > >> >> >> di oracle 9i, coba menggunakan statspack. >> >> ________________________________ >> >> From: Teguh Susanto <[email protected] <teguh4milis%40yahoo.com>> >> To: [email protected] <indo-oracle%40yahoogroups.com> >> Sent: Mon, August 16, 2010 10:33:14 AM >> >> Subject: [indo-oracle] OOT:tahapan apa saja untuk optimization tuning >> pada >> oracle 9i >> >> kepada miliser dan senior DBA >> >> kebetulan saya buat query dengan model pivot tapi pas dieksekusi lemot >> banget, >> tahapan apa saja untuk mengoptimasi query,tool apa saja yg bisa digunakan >> klo >> query yg saya buat bagus optimasinya, o ya saya menggunakan oracle jadul >> yaitu >> 9i >> >> terima kasih atas atensinya... >> >> [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] > > > > ------------------------------------ > > -- > -----------I.N.D.O - O.R.A.C.L.E--------------- > Keluar: [email protected] > Website: http://indooracle.wordpress.com > http://www.facebook.com/group.php?gid=51973053515 > ----------------------------------------------- > > Bergabung dengan Indonesia Thin Client User Groups, > Terminal Server, Citrix, New Moon Caneveral, di: > http://indo-thin.blogspot.comYahoo! Groups Links > > > > -- thanks and regards ujang jaenudin jakarta - indonesia
