Probao sam tvoj upit i ima jedan od najgroznijih execution planova koje sam ikada video. Nisam mogao da dočekam kraj rada pa sam ga prekinuo.
Ovaj modifikovani select radi neuporedivo brže.
Code:
select count(*)
from all_constraints ac, all_cons_columns acc --, all_tab_columns atc
where ac.constraint_type = upper('U')
and ac.constraint_name = acc.constraint_name
and ac.owner = acc.owner
--and ac.owner = atc.owner
and ac.table_name = acc.table_name
--and acc.column_name = atc.column_name
Nije mi baš najjasnije šta će ti all_tab_columns, kada sve što je potrebno imaš u druge dve tabele.
Kod mene je rezultat 2242.
Pozdrav
Registrovani: 95 ( sonus70, anakin14, zeus4, mivedra, Moreplovac, jelenaisasa, guja011, bokili, vladd, sicko, BiiigMuzzy, milos_a_k_a_godfather, smars, igii, siki2001, micas_08, cartmann, gojnik, stajaznam, vlax352, misteryh, igispasic, klipan2, anja 236, spulkan, richiezr, Vranac, djuricas, Mio_1, deki77, biggianthead, trst, zverkan, Buum, Au197/79, mihvasa, nemanja168, _str_, kajla, copyworld, lukivoda, marko_stamenkovic, Goran Mijailovic, dmlinko, kelja, Boki4u, beep, goran_kv, night-shift, kica78, psychedelic_knight, AstroDule, laki-91, Cartman, marko1101, ghost2k3, Milan Ogrizovic, kefaja, Renegade, savanah, dejankr, loo, dexkg, WAN, papens, tamindus, Miroslav Jeftić, okno, Novim, izida, shaxy, milan_kraljevo, bojan78, Lacika.1991, knell, Stefan Markic, Tamara_K, Slobodan Milivojevic, Joker, paklea1, milan67, yetta, milanpavke, sinisav, JankoNIS, bilbija, Milan Gligorijevic, JOJO847, Bata, buca2204965, biske86, dejanstamenkovic, calexx, Branko Santo, Kernel-1 )
Oracle tuning na 10g bazi