Oracle Optimization-double-edged sword

Oracle Optimization-double-edged sword

Oracle optimization is a double-edged sword. Pay special attention to the use of this sword:OLTP or OLAP

Optimization 1: Index

During DML operations, indexes must be maintained. If a large number of DML operations are performed, check whether I/O is too old?

Index advantages: in many cases, the query speed can be improved and the IO load can be reduced.

Optimization 2:

The primary key uses a sequence, and the cache size of the sequence is set.

If the cache settings are small, DML locks may occur.

If the cache is set to a large value and the database shuts down abnormally, the number of sent but not submitted caches will be discarded, resulting in a non-continuous primary key.

 

---- Unfinished (continuous update)