How do advanced query planning strategies such as multi-stage optimization, bushy tree optimization, and join order enumeration address the combinatorial explosion of query plan search space, improving the scalability and efficiency of query optimization algorithms across diverse query workloads?