Its possible, dont know if it will happen as we dont have DDL definitions and data here, for the two queries two produce the same execution plan on SQL Server. But the second version is defeintely more readable and easier to maintain. Just like Sql Server has a index advisor (not great) and a execution plan... see if Oracle has similar tools to guide your query development.