Learn Oracle Database pilotage three-database objects

I. Table-Paragraph

Table partitioning: Easy to delete operations, etc.

You can delete the partition table directly (quickly).

High efficiency when using conditions such as while.

Second, the index

Improve query speed

affect DML (update, INSERT, delete) efficiency

Updating the contents of the table also updates the contents of the index.

Third, Database link

Between two sets of data

A mechanism based on distributed transactions.

Four, table space

Can have multiple data files