Why it is preferred to create a table space on a partition other than the system partition?

Start networking and exchanging professional insights

Next Question:
Can we make or create another disk partition on computer even the operating syst...
Posted by:
Roderick Cabase
16-June-2014

Programming Databases PostgreSQL

Question added by عقبة بلخيري , Ingénieur d'état en Informatique , Administration
Date Posted: 2016/06/05

Upvote (0) Views (7) Followers (2) Answers (2) Report Question

Write an Answer
Register now or log in to answer.

2 Answers

by SYED Mubbashir Rehman , Application Support Engineer (Mid Level) , VERSCOM SOLUTIONS

Easy roll-in and roll-out of data.
Easier administration of large tables.
Flexible index placement.
Faster query processing.
Table partitioning improves performance by eliminating large amounts of I/O.

Upvote (0)

Downvote Reply () Report

by fahd soliman , programmer , National Agency for Network Services

to get the largest performance, that when Oracle system work on system partition, the other table space will be in hand and have the speed to read from other partition

Upvote (0)

Downvote Reply () Report