X hits on this document

88 views

0 shares

0 downloads

0 comments

23 / 48

Microsoft’s SAP ERP (R/3) System (cont)

Solution for Cached Query scenario1:

Split business logic in two statements like:

If @c2_value = ‘X sp_executesql ‘select * from t1… /* for X */ …, …, … else sp_executesql ‘select * from t1… /* for space */ …, …, …

Use same statement, but add different comments. SQL Server will not treat these two statements as the same statements, but different statements. Hence a plan for each of the cases is cached and used

Also can work for several data skews within one column.

Other possibility when one type of usage is in majority could be the usage of index hints. This is supported by SAP

DBA-416M• ISV configurations & implementations – Lessons Learned

Document info
Document views88
Page views88
Page last viewedSat Oct 29 00:23:54 UTC 2016
Pages48
Paragraphs862
Words4327

Comments