msimons4
asked on
indexes
I am partitioning a table that has indexes. Indexes for partitioned tables are either local or global. How do I determine if the index for my non-partitioned table is local or global?
the reason local/global doesn't apply is
local means the index is partitioned into pieces that correspond to the table partitions
global means it applies to the whole table
since there can't be "local" in non-partitioned it must be global, but it's sort of redundant to say so
local means the index is partitioned into pieces that correspond to the table partitions
global means it applies to the whole table
since there can't be "local" in non-partitioned it must be global, but it's sort of redundant to say so
ASKER
Great. So if my non-partitioned table has an index on 6 columns, is it better to use a global index on all 6 columns or a local on each column or do I not even have a choice. Am I able to have a global index on columns that are in different partitions?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
Thanks
If you want to pick one, then "global", but it doesn't really make sense to call it that