250 reputation
1215
bio website
location Berlin, Germany
age 31
visits member for 2 years, 6 months
seen Aug 8 at 14:03

Jul
21
awarded  Popular Question
Jul
12
awarded  Famous Question
Jul
2
awarded  Curious
Jun
3
awarded  Popular Question
May
8
awarded  Critic
Mar
10
asked Enable Oracle network encryption
Oct
27
comment Return a fully dynamic table from an Oracle function
@kevinsky, way better but I am on 3.6.2 and 3.x is not supported anymore .I am planning to migrate to 4.x next year. So, still outdated :-(
Oct
27
comment Return a fully dynamic table from an Oracle function
@kevinsky, thanks for the advise but this seems to be ages old -- Lucene 2.9. No option anymore.
Sep
26
comment Return a fully dynamic table from an Oracle function
@Ivan, XML isn't an option because it's to bloated.
Sep
19
awarded  Popular Question
Sep
5
awarded  Popular Question
Jun
6
comment Index on foreign key makes query extremely slow
@JackDouglas, yes that was my first thought when I saw the improvement. I think a weekly job should do it.
Jun
6
accepted Index on foreign key makes query extremely slow
Jun
6
comment Index on foreign key makes query extremely slow
@JackDouglas, yes this is how I understoood it now. I have ran another query with this range scan only. It performs fast, returns 1.14 million rows but still has overall costs of 26212. So this is simply the root cause. Since your answer led me into the right direction. It deserves an accept.
Jun
5
comment Index on foreign key makes query extremely slow
@JackDouglas, I am not using the hint. It was just used to see how the query would perform with the index after gathering stats. Getting back to the table, it has more than 60 millions rows. Probably that range scan makes the search extremely slow -- even with an index. I can attached a fully expanded tree. Will that help somehow? I narrowed it down to the important spot. Regarding the cardinalities, how can I enable this in SQL Developer? Thank you very much for the tips.
Jun
5
comment Index on foreign key makes query extremely slow
Plan has been generated. Please see the update on the question.
Jun
5
comment Index on foreign key makes query extremely slow
@ChrisSaxon, see my edit please.
Jun
5
revised Index on foreign key makes query extremely slow
added 680 characters in body
Jun
4
comment Index on foreign key makes query extremely slow
there is no recurring gathering of stats. How will that influence the execution plan? I am missing the link between the optimizer and the poor index-caused query.
Jun
4
comment Index on foreign key makes query extremely slow
@JackDouglas, as indicated in the tag, I am on 11.2.0.2.0. Quick means less than 10 seconds. The query runs in a webapp dozens of times per day. Prepared statements are employed.