0 - 3 of 3 tags for explain terminology
Avoid Product Join Step

Hi,
Could you please suggest how to avoid this product join step and explain about this step.
Usually how should i understand this kind of steps all stats seems to be up to date on these columns.
 

By Ashwin4tera, 25 Jul 2014 | Tagged: Avoid Product join Understand Step explain terminology | 6 comments
Group AMP Join in a 13.10 Explain plan

While testing the 13.10 version of the DBMS on our staging system, we found a query that performs much better under 13.10 and is using a "Group AMP Join", where the 12.0 version Explain plan references something completely different.  I am not familiar with the Group AMP Join and have been unsuccessful finding it in the 13.10 documentation searches I have

By mikesteeves, 26 Jul 2012 | Tagged: 13.10 explain terminology group amp join | 1 comment
Explaining the EXPLAIN

A topic that is essential for all SQL programmers and database designers. This session examines the mysteries of the English text that appears when an EXPLAIN is requested.

By DebraH, 09 Jan 2012 | Tagged: explain visual explain optimizer plans explain terminology explain text