What Are The Heuristic-processing Strategies?

1.	What Are The Heuristic-processing Strategies?
Answer» PERFORM selection operation early so that we can eliminate a MAJORITY of the CANDIDATE rows early in the operation. If we leave most rows in until the end, we're going to do needless comparisons with the rows we're going to get rid of later. Perform projection operations early so that we limit the number of columns we have to deal with. If we need to perform consecutive join operation,perform the operations that produce the smaller join first. COMPUTE common expressions once and save the RESULTS.

Answer»

PERFORM selection operation early so that we can eliminate a MAJORITY of the CANDIDATE rows early in the operation. If we leave most rows in until the end, we're going to do needless comparisons with the rows we're going to get rid of later.
Perform projection operations early so that we limit the number of columns we have to deal with.
If we need to perform consecutive join operation,perform the operations that produce the smaller join first.
COMPUTE common expressions once and save the RESULTS.

Discussion