SELECT...WHERE Statement Interface

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

SELECT...WHERE Statement Interface

Figure 27 shows the order in which the database server executes purpose functions for a SELECT statement with a WHERE clause. For information about how to process the scan and qualifications, refer to Processing Queries.

Figure 27. Processing a SELECT Statement Scan

Flowchart shows am_scancost pointing to am_open, which points to am_beginscan, which points to am_getnext. If the am_getnext returns MI_ROWS, the scan executes am_getnext again. If am_getnext returns MI_NO_MORE_RESULTS, the scan continues to am_endscan, which points to am_close.