Hello all,
Good day. I've a question regarding the access plan using Full table scan and Index Range Scan.
Below is the sample SQL vstatement:
Select * from TABLE1 Where MANDT = 001 and PROJR = 100
There is a index which contains the fields in the above WHERE Clause but the selectivity (or Distinct number) is only 1 for both fields.
INDEX TABLE1~0
==============
Fields, #Distinct
==============
MANDT, 1
PROJR, 1
The table size is 3,200,000KB (3.2GB) and index size for TABLE1~0 is 180,000KB (180MB).
My question is: If using Full table scan is more efficient than index range scan, what could be the reason and is there any document/SAP Note is discussing this?
Thanks,
KP