O'Reilly logo

Tera-Tom Genius Series - Kognitio Architecture and SQL by Leona Coffing, Tom Coffing

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.

Start Free Trial

No credit card required

Chapter 19 – Kognitio Explain

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

- Anonymous

How to See an EXPLAIN Plan

image

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.

Start Free Trial

No credit card required