Home | Previous Page | Next Page   Purpose-Function Reference > Purpose-Function Flow >

CREATE Statement Interface

Figure 23 and Figure 24 show the order in which the database server executes purpose functions for a CREATE TABLEINDEX statement. If the IN clause specifies multiple storage spaces to fragment the index, the database server repeats the sequence of purpose functions that Figure 23 and Figure 24 show for each storage space.

Figure 23. Processing a CREATE TABLE Statement
Flowchart shows am_create pointing to am_open, pointing to am_close.

Figure 24. Processing a CREATE INDEX Statement
Flowchart shows am_create pointing to am_open, pointing to am_insert key, pointing to a box that says "More rows?" If the answer is Yes, am_insert key is executed again in a loop until the answer is No. If the answer is No, am_close is executed.

For more information about implementing the CREATE INDEX statement in the access method, refer to Supporting Data Definition Statements.

Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]