Why do I need "Internal ID"?

From: Ben Heuer <queerczarNOquSPAM_at_unforgettable.com.invalid>
Date: 2000/07/30
Message-ID: <090b7be8.aab0f473@usw-ex0105-034.remarq.com>#1/1

HI,

In most of our tables, we have an internal ID field..why is this? Lets say we have a customer_id in the CUST table and an order id in the ORDER table..why do we need a customer_int_id and an order_int_id in each table??

These int_id fields are hardly used for any linkages, could they be used for indexing? Why not just use the order_id and the cust_id fields for indexing??

Thanks!

Got questions? Get answers over the phone at Keen.com. Up to 100 minutes free!
http://www.keen.com Received on Sun Jul 30 2000 - 00:00:00 CDT