Re: Multiple 1-1 tables better performance

"Richard Lynch" <[EMAIL PROTECTED]> wrote on 03/10/2005 05:13:09 PM: > Apologies if this comes through twice... > I *think* I fargled the To: the first time... > > My boss is claiming that having multiple 1-1 tables, with an index on the > keys, is better performance. > > Example of his claim:

Multiple 1-1 tables better performance

Apologies if this comes through twice... I *think* I fargled the To: the first time... My boss is claiming that having multiple 1-1 tables, with an index on the keys, is better performance. Example of his claim: table_1: person_id, name, phone table_2: person_id, address, city, state, zip, count