X hits on this document

140 views

0 shares

0 downloads

0 comments

26 / 48

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

Query scenario:

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

Primary Key Constraint (clustered index) doesn’t contain Date, but non-clustered index on Client, Date exists. Client only has one distinct value

Dependent on the range specified over Date, Query Optimizer needs to decide on:

Using non-clustered index in order to retrieve the rows

Using Clustered Index scan

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

Last value: 20070331

First value: 20040701

Real Last data entry: 20070912

Document info
Document views140
Page views140
Page last viewedWed Jan 18 04:02:30 UTC 2017
Pages48
Paragraphs862
Words4327

Comments