Stay ahead with the world's most comprehensive technology and business learning platform.

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training,
learning paths, books, tutorials, and more.

Chapter 19 – Kognitio Explain

“Write a wise saying and your name will live forever.”

- Anonymous

How to See an EXPLAIN Plan

Diagnostic on kognitioaws for 7.02.01-rel120813:

1 We apply 1 shared lock on table EMPLOYEE_TABLE(1086).

2 We select rows from the randomly distributed table EMPLOYEE_TABLE(1086).From these rows, a result set will be generated containing 5 columns.The results will be prepared to be fetched by the interpreter.Approximately 9 rows will be in the result set with an estimated cost of0.039.

3 We fetch rows and send them to the user.

-- Estimated Total Cost : 0.047

To get an EXPLAIN you can either type the word EXPLAIN in front ...

With Safari, you learn the way you learn best. Get unlimited access to videos, live online training,
learning paths, books, interactive tutorials, and more.