Question: how heuristic query optimization is performed?
Answer: Heuristic Based Optimization Perform select and project operations before join operations. This is done by moving the select and project operations down the query tree. This reduces the number of tuples available for join. Perform the most restrictive select/project operations at first before the other operations.