Home » RDBMS Server » Server Administration » partition table
partition table [message #60432] Sat, 07 February 2004 17:46 Go to next message
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 Go to previous message
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
Previous Topic: row chaining
Next Topic: ORA-0650 error
Goto Forum:
  


Current Time: Wed Jan 22 18:59:53 CST 2025