209 reputation
29
bio website
location
age 30
visits member for 2 years
seen Aug 14 '13 at 2:46

Oct
2
comment Why does the query cost change so much and how to prevent it
@Phil The stats are fine, but thanks. And, there isn't any reason to not join.. I actually did try that, thats what I meant with "I have tried to isolate the "small query" in a with clause, tried to use an join instead a sub query", sorry if it was ambiguous.
Oct
2
asked Why does the query cost change so much and how to prevent it
Sep
27
comment Use of hash functions in group by?
You read it correctly, but it isn't the whole story. I've made it short so I could explain the question, but this comparison is just part of a whole process which isn't even executed by Oracle. What you said is probably a better idea in most cases but here I'd just want to generate the hashes to feed my other process (responsible for the comparison).
Sep
27
awarded  Supporter
Sep
27
accepted Why Is oracle ignoring my index?
Sep
27
accepted Help to understand explain plan in Oracle
Sep
27
asked Use of hash functions in group by?
Sep
12
revised Why Is oracle ignoring my index?
deleted 1 characters in body
Sep
12
asked Why Is oracle ignoring my index?
Sep
10
comment Help to understand explain plan in Oracle
Well, I was hoping for something like "the heaviest part of your query is the search on costumer_price_history by such field as shown in such line of the explain plan"
Sep
10
comment Help to understand explain plan in Oracle
Done. thanks for the heads up.
Sep
10
revised Help to understand explain plan in Oracle
edited tags
Sep
9
revised Help to understand explain plan in Oracle
added 65 characters in body
Sep
9
asked Help to understand explain plan in Oracle
Aug
15
revised Dodgy causes of ORA-12549?
added 151 characters in body
Aug
15
awarded  Scholar
Aug
15
accepted Dodgy causes of ORA-12549?
Aug
7
asked Dodgy causes of ORA-12549?
Jul
29
awarded  Editor
Jul
29
awarded  Student