Skip to Content
0
Former Member
Apr 19, 2010 at 01:37 PM

Full table scan vs Index Scan

1525 Views

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