partition table [message #60432] |
Sat, 07 February 2004 17:46 |
ashokmote
Messages: 56 Registered: December 2003
|
Member |
|
|
when u create partition on table.and when user access table he get information from partition table.which process take care all these things ,i mean which process knows that this table as partition table and user must access from this partition table.
|
|
|
Re: partition table [message #60511 is a reply to message #60432] |
Wed, 11 February 2004 09:43 |
ilver
Messages: 50 Registered: January 2004
|
Member |
|
|
Hi,
If I get you right (I'm not sure):
It its the optimizers job to prune partitions ( exclude irrelevant partitions) the optimizer doesn't have a dedicated process, but is an integrated part of the Oracle engine.
/ilver
|
|
|