Where can I find the order of operations which are evaluated by Oracle database? I mean, for example, that for a query like this:
select something, rank over ( partition by .. order by ... ) r
from t1, t2
where t1.x = t2.x
and t2.other_something = 'value'
order by 1;
it can be said that: "order by" goes last, "rank" works on rows after the tables are "joined" and rows "selected". So in a sense there is some order of operations performed. I understand that actual order of operations during execution may be different if optimizer finds out an equivalent, alternative execution plan. But what is a sort of "basic" order op operations Oracle follows "to understand" the query even before it tries to figure out alternative form. Is there such list of operations order?
Thank you