LucidDbExplainPlan

Syntax

EXPLAIN PLAN
[ { EXCLUDING | INCLUDING [ ALL ] } ATTRIBUTES ]
[ { WITH | WITHOUT } IMPLEMENTATION | WITH TYPE ]
FOR { query-statement | insert-statement | update-statement | delete-statement | merge-statement }

See LucidDbQueryStatement for specification of query-statement.

See LucidDbInsert for specification of insert-statement.

See LucidDbUpdate for specification of update-statement.

See LucidDbDelete for specification of delete-statement.

See LucidDbUpsert for specification of merge-statement.

Example

EXPLAIN PLAN FOR
SELECT DISTINCT ename, job
FROM timesheet_fact t, employee_dimension e, calendar_dimension c
WHERE t.emp_key=e.emp_key
AND t.workday_key=c.calendar_key
AND c.is_weekend;