X hits on this document

175 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 views175
Page views175
Page last viewedTue Jan 24 20:01:31 UTC 2017
Pages48
Paragraphs862
Words4327

Comments