With regards to sql profile: will it be accepted for identical statements with different schema?
hi,
With regards to sql profile: will it be accepted for identical statements with different schema?
Assume that ACCEPT_SEQUEL_PROFILE is set to TRUE.
From example, let says the sql optimizer accepted sql profile "SYS_SQLPROF_016870b70a9b0000" for below query
select * from A_OWNER.EMP, A_OWNER.DEP WHERE <COMPLEX_CONDITION>;
will the optimizer also use the sql profile for the query below? Schema names are different.
select * from B_OWNER.EMP, B_OWNER.DEPT WHERE <COMPLEX_CONDITION>;
The queries are exactly the same except for schema owner A_OWNER vs. B_OWNER.
I believe the answer is "No" even if EMP and DEPT table were exactly same structure and exactly same data, the sqls are considered different.