Re: How to handle secondary keys in partitioning?
I'm not sure if I understand what you ask about, but I'll try to explain what I think you are looking for:
Partitioning handles indexes automatically, also secondary indexes, so you do not have to do queries for each partition separately. Partitioning also make use of indexes for lookups and sorting, just like non partitioned tables.
An ordered index read from a partitioned tables is implemented by the partitioning handler ha_partition by:
1) do an ordered index read from each partition that is not pruned away
2) use a priority queue (merge sort) to return the 'first' row
3) do an index next read from the partition which the returned row came from (i.e. keep the priority queue filled with one row per partition).
That way you (as a user) do not have to query each partition your self or sort the result without making use of the index.
Subject
Views
Written By
Posted
4343
May 04, 2010 12:46AM
Re: How to handle secondary keys in partitioning?
2433
May 04, 2010 01:29PM
2074
May 04, 2010 04:30PM
2292
May 05, 2010 02:20AM
2134
May 06, 2010 12:04AM
2535
May 06, 2010 03:23PM
2179
May 06, 2010 10:50PM
2147
May 07, 2010 02:38AM
2100
May 08, 2010 05:31PM
2166
May 09, 2010 04:37AM
2050
May 09, 2010 12:41PM
2036
May 09, 2010 01:23PM
2122
May 12, 2010 05:29AM
2564
May 06, 2010 12:34AM
Sorry, you can't reply to this topic. It has been closed.
Content reproduced on this site is the property of the respective copyright holders.
It is not reviewed in advance by Oracle and does not necessarily represent the opinion
of Oracle or any other party.