PRETTY | PRETTY_COLOR Specifies to connect the parent and child nodes in the plan tree with tree lines or colored tree lines to make the execution plan easier to read. BASIC The basic information about the outpu
In addition to the row source tree, the plan table contains information about the following: Optimization, such as the cost and cardinality of each operation Partitioning, such as the set of accessed partitions Parallel execution, such as the distribution method of join inputs The EXPLAIN PLA...
the execution plan is available for the entered statement and the explain plan button is selected in the query window. The logged in user also needs the necessary privileges, see the sections below for more information about privileges. If you wish not to get the plan by default every time a...
Please direct questions about technical support or the Study.com website to customer support. Drop photo or image here to upload or select file Get Answer By submitting, I am agreeing to the Terms of Use and Honor Code. Already a member? Log i...
If you see any good use of the feature, please blog about it. Your example “a screenshot with query just single child cursor” is just a toy example that has nothing to do with real business. Please, do that. I’ll be happy to learn something new. ...