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