The greater the precision with which you specify the desired rows, the greater the likelihood that your queries will complete quickly. To control the amount of information that the query evaluates, use the WHERE clause of the SELECT statement. The conditional expression in the WHERE clause is commonly called a filter.
For information on how filter selectivity affects the query plan that the optimizer chooses, see Filters in the Query. The following sections provide some guidelines to improve filter selectivity.
Enterprise Edition Home | Express Edition Home | [ Top of Page | Previous Page | Next Page | Contents | Index ]