My first experience in parameter sniffing? any opinions? Should I use hint?

[former_member211576]

Hi experts,

  As you see in screenshot 1, we found a standard program(not modified) SAPLCSIO consumes high percentage of total
time.

  In screenshot 2, it runs very long sometimes.

  I capture SQL statement below and the parameter from DBACockpit->Performance->SQL statements. According to
where clause, it should use MAST~S but actual execution plan used MAST~0

  DB05 shows distribution is not normal.

  Select … group by shows 33,433 duplicated records.

[former_member211576]

[former_member211576]