Is indexing on 5 keys of a table containing 100 fields more slower than indexing on same 5 keys of a table containing 150 fields.
Both the tables (one containing 150 fields and other containing 100 fields) are similar except the 50 attributes which are redundant.
Suppose there are 2 attributes common to both the tables.
Will a query fetching the 2 attributes run faster on 100 field table compared to that on 150 field table?
Can you please give the reasons?
November 23, 2005 8:08 AM
November 23, 2005 4:37 PM