About Best SQL Alternative Selection Criteria

SQL Optimizer SQL Optimizer for Oracle
1

Hi ALL,

I heard that SQL Optimizer get logical read coutn from dynamic performance view when i execute queries after optimization.

becuase the values from dynamic performance view could be show different result
when i execute quries several time
I hope i could select traced values(ex. traced logical read) in Best SQL Alternative
Selection Criteria.

could you check case id : 628723?

Thanks,
woong

2

Hi Woong,

Thank you for the feedback. I have checked your case and will add your request to our enhancement list.

If you have other questions or suggestions in the future, please feel free to post it in this community.

Thanks,
Alex