Skip to main content

You are not logged in. Your edit will be placed in a queue until it is peer reviewed.

We welcome edits that make the post easier to understand and more valuable for readers. Because community members review edits, please try to make the post substantially better than how you found it, for example, by fixing grammar or adding additional resources and hyperlinks.

Required fields*

15
  • 2
    Show the query with group by. Commented Dec 19, 2012 at 16:29
  • I don't have the answer to your question, but I expect that seeing BOTH queries, their explain plans and the number of logical GETs might help in understanding (FWIW I would have expected DISTINCT to have a performance advantage, if at all). Commented Dec 19, 2012 at 16:30
  • In SQL Server you can get Query Execution Plans.. can you get something similar in Oracle? That would tell you where the difference was. Commented Dec 19, 2012 at 16:31
  • 1
    BTW: why the big long chain of LEFT joins when you only want records with a 'TYPE A' at the end? Commented Dec 19, 2012 at 16:31
  • Two things; 1) Put your GROUP BY query in your question and 2) Run an EXPLAIN PLAN on each query and also add the output to the question. Commented Dec 19, 2012 at 16:32