Skip to Content
author's profile photo Former Member
Former Member

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

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.

Add a comment
10|10000 characters needed characters exceeded

Related questions

1 Answer

  • Best Answer
    Posted on Aug 26, 2009 at 04:09 PM

    Hi Hari,

    no, each of your query has to perform the same amount of I/O.

    Since you are using the fully specified primary key both queries will

    perform an index unique scan. This index uniques scan in both cases

    has to read some inex blocks/pages depending on the height of the index

    and in case of heap tables an additional table block/page.

    Kind regards,

    Hermann

    Add a comment
    10|10000 characters needed characters exceeded

Before answering

You should only submit an answer when you are proposing a solution to the poster's problem. If you want the poster to clarify the question or provide more information, please leave a comment instead, requesting additional details. When answering, please include specifics, such as step-by-step instructions, context for the solution, and links to useful resources. Also, please make sure that you answer complies with our Rules of Engagement.
You must be Logged in to submit an answer.

Up to 10 attachments (including images) can be used with a maximum of 1.0 MB each and 10.5 MB total.