The SELECT...WHERE statement interface The following figure shows the order in which the database server executes purpose functions for a SELECT statement with a WHERE clause.Figure 1: Processing a SELECT statement scan