X hits on this document

95 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 views95
Page views95
Page last viewedMon Dec 05 14:49:17 UTC 2016
Pages48
Paragraphs862
Words4327

Comments