Shoiuld i implement/accept this recommendations/SQL profile ? if i accept it and any adverse effect occur then how can i revert it back.
SQL Profile A potentially better execution plan was found for this statement. Consider accepting the recommended SQL profile.
Pavan Kumar wrote:That's a piece of code that will tell you what the profile looks like AFTER you've accepted it.
Additionally, some information the below query can provide the sql profile adjustments.
select sp.sp_name, sa.attr#, sa.attr_val from sqlprof$ sp, sqlprof$attr sa where sp.signature = sa.signature and sp.category = sp.category order by sp.sp_name, sa.attr# ;