X hits on this document

107 views

0 shares

0 downloads

0 comments

27 / 48

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

Query scenario (cont):

Select * from Sales_Order_Header where Client=‘300’ and Date between ‘20070101 and ‘20070110’

Date range small and 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 200K rows

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

Last value: 20070330

First value: 20040701

Real Last data entry: 20070912

Selected Range

Document info
Document views107
Page views107
Page last viewedThu Dec 08 04:36:22 UTC 2016
Pages48
Paragraphs862
Words4327

Comments