Why do we use heuristic method of query optimization?

Any query will have better performance when tables with few records are joined. Hence throughout heuristic method of optimization, the rules are formed to get less number of records at each stage, so that query performance is better. So is the case here too. Suppose we have STUDENT, CLASS and TEACHER tables.
For More Information Please Refer:


You May Also Like to Read: