|
The Create Indexes functionality in CES Database Administration allows you to do the following: |
|
You can analyze all properties and generate reports and scripts. The topics covered in this section are: | |
|
This task explains how to analyze all properties and generate reports and scripts: | |
![]() |
|
|
After analyzing the properties, you can view the recommendation report. | |||||||||||||
|
This task explains how to view the recommendation report. | |||||||||||||
![]() |
|
|
After analyzing the properties, and viewing the report, you can create indexes. | |
|
This task explains how to create indexes. | |
![]() |
|
|
The Creating an Index allows you to create an index for a specific class in CES Administration Database. |
|||||||||||||
|
This task explains how to create an index for a specific class: | |||||||||||||
![]() |
|
|
A Function Based Index (FBI) is
an index or an expression of a column. When you search a column where a
column function is required, such as UPPER ( |
|
You can create/Drop a function based index in the CES Administration Base: |
|||||||||||||||
|
This task explains how to create/drop a function based index: | |||||||||||||||
![]() |
|
|
When you select the class for the FBI needs to be defined, the eligible properties are displayed. |
|
This task explains how to create a function based index: |
![]() |
|
|
When you select the class for the FBI needs to be defined, the eligible properties are displayed. |
|
This task explains how to drop a function based index: |
![]() |
|