When should we go for hash partitioning? - oracle

When should we go for hash partitioning?

Scenarios for choosing hash partitioning:

- Not enough knowledge about how much data maps into a give range.
- Sizes of range partition differ quite substantially, or are difficult to balance manually
- Range partitioning would cause data to be clustered undesirably.
- Features such as parallel DML, partition pruning, joins etc are important.
What is Materialized view? What is a snapshot? - oracle
Materialized view and snapshot - A materialized view is a database object that contains the results of a query. A snapshot is similar to materialized view...
Advantages of running a database in NO archive log mode - oracle
NO archive log mode - 1. Less disk space is consumed 2. Causes database to freeze if disk gets full...
Advantages of running a database in archive log mode - oracle
Advantages of running a database in archive log mode - It makes it possible to recover database even in case of disk failure...
Post your comment