X hits on this document

151 views

0 shares

0 downloads

0 comments

28 / 48

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

Query scenario (cont):

Select * from Sales_Order_Header where Client=‘300’ and Date between ‘20061201 and ‘20070331’

Date range larger and within statistics of column ‘Date’

Query Optimizer decides for accessing the table via clustered index due to cardinality estimate based on statistics of around 8 Mio rows

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

Last value: 20070331

First value: 20040701

Real Last data entry: 20070912

Selected Range

Document info
Document views151
Page views151
Page last viewedFri Jan 20 05:56:13 UTC 2017
Pages48
Paragraphs862
Words4327

Comments