Projects:DB Support Indexes With Functions/QA

Automated Tests

The FunctionBasedIndexes class has been added to the ModelSuite in the DBSMTest project. That class contains the following tests:

• importBasicIndex: Checks that indexes not based on functions are imported properly
• exportBasicIndex: Checks that indexes not based on functions are exported properly
• importFunctionBasedIndexes: Checks that function based indexes are imported properly
• exportFunctionBasedIndexes: Checks that function based indexes are exported properly
• exportNonMonadicFunctionBasedIndex: Checks that function based indexes that use functions whose number of input parameters is not 1 are not exported

Each of these tests is executed several times, according to the following parameters: - Database type and version - Test Type: {onCreate, onDefault}. When the test type is onCreate, the indexes will be created in the create.database process, otherwise they will be created in the update.database process, after having loaded a base madel using create.database.

So far these tests have been run using PostgreSQL 9.1 and Oracle 11.2

Performance Tests

In an OB instance having 7 million business partners, creating a simple index on the value column took 134 seconds, and creating a function based index using upper took 142 seconds.

The increase in the insertion time after creating the function based index is negligible.