I have a table (ZTEST) with two key fields , say, sales org (first key field ) and material.
Material ABC exists in sales orgs 001 and 002.
Total number of records in table for salers org 001 = 1 million
Total number of records in table for salers org 002 = 10000
If I select from ZTEST using
1 . sales org = 001 and material = ABC
2. sales org = 002 and material = ABC
will there be a significant time difference between the two queries ?