Comment by Jweb_Guru

Salesforce literally has its own query optimizer, you are vastly underestimating the complexity of its software.