As for question 1: the overhead will be exactly the same in both index
layout scenarios. The only deciding factor is how your application
uses this data.. the choice of structure has only to do with finding
what accelerates application quiries most effectively.
Question 2: by all means, add the
I have two questions about the overhead associated with updating the
indexes when records are added, deleted or modified. Lets say I have a
table of 1 million records that is partitioned on partitionedfield (10
distinct values).
id int
partitionedfield int
property1 int
property2 int
property
