Yes, I would expect it to be faster. There will be less data to retrieve.

>Hi, all!
>
>I have a general question for the crowd:
>
>Let's say I have 10 million records in an inventory table with an indexed field on part number. We have a related table of 10,000 different parts.
>
>If I SQL-Select things from the inventory with:
>
>SELECT * FROM inventory WHERE partno = 54321 INTO CURSOR cTemp
>
>the select will take a small amount of time.
>
>Now, let's say we archive off 5 million records (and pack!) the inventory table. Now, only 5,000 different parts are in the inventory table, because we archived off records for the other 5,000.
>
>My question: "Would you expect SQL-Selects by part number from the 5 million record table to be faster or slower, and why?"
>
>The reason I'm asking is that we have a client who wants to split their large tables in two for speed reasons.
>
>Thanks.
>
>- George