X hits on this document

118 views

0 shares

0 downloads

0 comments

30 / 48

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

Query scenario (cont):

Select * from Sales_Order_Header where Client=‘300’ and Date between ‘20070501 and ‘20070831’

Date range larger and only start date 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 1 row

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

Last value: 20070630

First value: 20040701

Real Last data entry: 20070912

Selected Range

Document info
Document views118
Page views118
Page last viewedFri Dec 09 23:12:03 UTC 2016
Pages48
Paragraphs862
Words4327

Comments