Supplement to "Indexing" in Oracle Tuning

Supplement to Oracle optimization ldquo; index building rdquo;

Supplement to Oracle optimization ldquo; index building rdquo;

Indexing is a good method for tuning and greatly improving the query speed.

However, in addition to creating an index for each field, you can also create an index as follows:

1. Create a joint index for the query condition:

Combine all fields used by a table in the query condition to create an index, which improves the query efficiency.

2. Create a joint index for the query results

Combine all the fields found in a table in the query results to create an index, which improves the query efficiency.

3. Create a unique Index Based on Multiple Fields

Unique indexes are not necessarily determined by the primary key. If multiple fields can be combined to uniquely identify a data record, they can be combined to create an index.