Skip to Content
0
Former Member
Aug 26, 2009 at 03:30 PM

Select using primary key, does it depend on volume of data ?

20 Views

Hi ,

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 ?

Regards,

Hari.