X hits on this document

125 views

0 shares

0 downloads

0 comments

29 / 48

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

Query scenario (cont):

Select * from Sales_Order_Header where Client=‘300’ and Date between ‘20070320 and ‘20070410’

Date range small and only start value within statistics of column ‘Date’

Query Optimizer decides for accessing the table via non-clustered index due to cardinality estimate based on statistics of around 300K rows

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

Last value: 20070631

First value: 20040701

Real Last data entry: 20070912

Selected Range

Document info
Document views125
Page views125
Page last viewedSat Dec 10 18:38:44 UTC 2016
Pages48
Paragraphs862
Words4327

Comments