|
|
Re: how sql fetches records from diffrent partitions of table [message #423263 is a reply to message #423246] |
Wed, 23 September 2009 03:11   |
navneet_sharma
Messages: 70 Registered: September 2008 Location: New Delhi, India
|
Member |
|
|
Hi,
I will explain my question by following example :
select * from my_table where country_id in ('US','CN');
my_table is partitioned on country_id column.Now I want to know how oracle fetch records from diffrent partitions (in my example 'US' and 'CN') and then merge the outputs into one single result.
What I mean is that how oracle provides this abstraction,means user is not bothered about how the data is saved internaly in diffrent partitions and how it would be fetched and merged into single output ,for him there is exatraction of data from single table.
I think now the question is clear.
[Updated on: Wed, 23 September 2009 03:22] by Moderator Report message to a moderator
|
|
|
Re: how sql fetches records from diffrent partitions of table [message #423266 is a reply to message #423263] |
Wed, 23 September 2009 03:18   |
JRowbottom
Messages: 5933 Registered: June 2006 Location: Sunny North Yorkshire, ho...
|
Senior Member |
|
|
Quote:I think now the question is clear. Sadly, it'w whether we can understand the question that matters, and I'm still confused.
I can't see what there is here to explain - all the partitions are part of the same table and they all have the same row structure.
Oracle fetches data from one or more partitions and returns it - what is there about this that needs explaining with regards to partitions?
|
|
|
|
|
|