pms_reddy1
asked on
Table Partitions
What is table partitioning?
Howmany types of partitions are there?
Please provide more details about Hash partitioning,When should we use hash partitioning,
Please provide some examples.
Thanks,
Howmany types of partitions are there?
Please provide more details about Hash partitioning,When should we use hash partitioning,
Please provide some examples.
Thanks,
ASKER
Hi,
I know in Oracle site we can get the documents.Since I am working multiple technologies & multiple projects I do not have time to go through the huge volumes of info.
If you already having knowledge on the topics please share with us,It will be helpful for the readers.
Along with the explanation if you can share the reference links it would be well and good,
I hope you can understand the problem.
Thanks,
I know in Oracle site we can get the documents.Since I am working multiple technologies & multiple projects I do not have time to go through the huge volumes of info.
If you already having knowledge on the topics please share with us,It will be helpful for the readers.
Along with the explanation if you can share the reference links it would be well and good,
I hope you can understand the problem.
Thanks,
I'm not sure anyone can provide you with the general overview of what you are asking better than the docs can. If you need someone to read through documentation and provide sort of an executive summary, I suggest hiring a research assistant.
The different types are partitioning available are right there in the links I provided. There aren't huge volumes to go through. Open the link and scan a page or two.
Here is a copy/paste form the first few lines of the first link I posted:
Partitioning Strategies
Oracle Partitioning offers three fundamental data distribution methods as basic partitioning strategies that control how data is placed into individual partitions:
•Range
•Hash
•List
Using these data distribution methods, a table can either be partitioned as a single list or as a composite partitioned table:
•Single-Level Partitioning
•Composite Partitioning
Each partitioning strategy has different advantages and design considerations. Thus, each strategy is more appropriate for a particular situation.
The different types are partitioning available are right there in the links I provided. There aren't huge volumes to go through. Open the link and scan a page or two.
Here is a copy/paste form the first few lines of the first link I posted:
Partitioning Strategies
Oracle Partitioning offers three fundamental data distribution methods as basic partitioning strategies that control how data is placed into individual partitions:
•Range
•Hash
•List
Using these data distribution methods, a table can either be partitioned as a single list or as a composite partitioned table:
•Single-Level Partitioning
•Composite Partitioning
Each partitioning strategy has different advantages and design considerations. Thus, each strategy is more appropriate for a particular situation.
ASKER
Is there any way to select the perticular partition in the "where clause" if I want to select the records from partition_1?If so,is that applicable to all of the patition types(Range,Hash,..)
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Are you not wanting to read the docs?
The 'types' are here:
http://docs.oracle.com/cd/E11882_01/server.112/e25523/partition.htm#autoId17
Hash partitioning here:
http://docs.oracle.com/cd/E11882_01/server.112/e25523/partition.htm#autoId20
The docs even say when it is ideal to use...
Excerpt from the link: Hash partitioning is the ideal method for distributing data evenly across devices