106 reputation
6
bio website howfuckedismydatabase.com
location Krasnoyarsk / Moscow, Russia
age 31
visits member for 2 years
seen Aug 20 at 4:41

Jul
12
comment How to optimize query?
1. show us your table definition and execution plan. 2. execute the same query in SQL*Plus and check the timing. 3. you mean, 376, not 376000?
Dec
29
comment 9i streams capture doesn't evaluate rules
@Threaten there are no (visible) errors or warnings. capture process' status is active. it just does nothing (or something I mentioned above)
Dec
10
comment Oracle aggregate functions slows query down massively
@user1578653 can you post autotrace for both queries also?
Oct
2
comment How to modify an update in Oracle so it performs faster?
@StrayChild01 if FEE_SCHEDULE_HISTORICAL + ETL_FEE_SCH_TMP = FEE_SCHEDULE, why do you perform additional costly FTS exists check for FEE_SCHEDULE at all, if you are somewhat sure to have all the data in former two tables which you joined? doesn't make sense to me.