Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

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

user-image
Question ajoutée par عقبة بلخيري , Ingénieur d'état en Informatique , Administration
Date de publication: 2016/06/05
SYED Mubbashir Rehman
par 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.

fahd soliman
par 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

More Questions Like This