Oracle performance optimization achieved through Partitioning technology

Database performance optimization

Oracle features: Partitioning technology

Partition Index

More record tables and indexes.

Create an index or partition. Partition Index

Basic principle: the physical location of the created table must be different from that of the created index!
Equivalent to: index the dictionary text before the dictionary on two hard disks respectively!

Query Information:

Index: An ordered table (only indexed columns in the table)

Indexed table: index the table data (in SQLServer, it is called a clustered table)

The primary key is irregular and cannot be indexed. For example, the GUID-nic generates a 16-character string.

Multiple table connections usually involve a large amount of data.

10*100 connections: 100 that meet the conditions

The 100 results are obtained after calculation.

If you save the join results in a table in advance, the efficiency will certainly be higher.

This type of table clustering table

Index

Common Index: The value can be repeated.

Create index xx on table (name ); ... Where name = 'xxx'; name like 'Li %' Where name! = 'Lee %'

Unique index: PK is the unique index

Create unique index xx on table (ID card );

Query all

Where substr (name, 1, 1) = 'lil'

Create a function index.

Create index xx on table (substr (name, 1, 1 ));

How do I create fields for departments and gender?

Features: There are many duplicate values.

Gender

Oracle creates a reference for each value. Only the reference is saved in the index.

Bitmap Index

create bitmap index xxxxx;

Reverse Index

Select * from t_news where rownum <= 10 Order by posting date desc

Create reverse order index .. on (posting date );
2009-2-1
2009-1-

What you are reading is Oracle performance optimization achieved by Partitioning technology

1. A simple view on Oracle concurrent processing mechanism
2. Three methods to simplify the management of Oracle table columns
3. What Oracle DBA must understand in the new environment