PE steps when executing a Create table request

Database

PE steps when executing a Create table request

Hi All,

 

What are the steps taken by PE while executing a create table request ?

Wanted to understand steps taken in each part of PE.

1 REPLY
Highlighted
Senior Apprentice

Re: PE steps when executing a Create table request

Hi,

The steps taken by the PE for CREATE TABLE are pretty much the same as for any request.

Syntax parser

Some dictionary validation

Security

Optimizer

- then the PE becomes a dispatcher and sends commands to the AMPs

 

Remember that you can EXPLAIN a CREATE TABLE request, but those are the AMP steps, not PE steps.

 

HTH

Dave

Ward Analytics Ltd - information in motion
www: http://www.ward-analytics.com