SQL Profiles and different users running the same SQL
If Enterprise Manager suggests a SQL Profile that will improve performance for a specific SQL ID and I accept it, will other users automatically use the same profile even if it is not in the parsing schema? For instance, If user A runs a query that is exactly the same (same SQL ID) as user B and user A is the parsing schema when the profile was recommended, will user B automatically use that execution plan as well or is it on a user-by-user basis?
0