Hi

I have an issue regarding database indexes. I can't search data using btree index. I have tried rebuilding all the indexes using the database tool in OI.10 but that doesn't help. Then I try to rebuild the indexes using OI 9 and my index problems are solved. Must I always use OI 9 to rebuild the indexes ? Why can't the database tool in OI 10 fix the index problems ?

My OI 9 and OI 10 are sharing the same tables and we are using UD 5.2. 

Thank You

The way that indexing works in 10 is different by default than in 9. This has the potential to confuse mixed systems. If you are sharing between 9 and 10 we'd strongly recommend editing or creating a record in SYSENV, CFG_RTI_UPDATE_INDEX then putting RTI_UPDATE_INDEX_90 in line 1 and saving it, exiting OI 10 and restarting. This will force 10 to use 9 indexing logic.

We've been working a lot with indexes on large files in 10 and we'd recommend using this setting in any case if you're working with large data volumes. By large, we are talking tens of millions of rows.

The Sprezzatura Group

The Sprezzatura Blog

World leaders in all things RevSoft

The way that indexing works in 10 is different by default than in 9. This has the potential to confuse mixed systems. If you are sharing between 9 and 10 we'd strongly recommend editing or creating a record in SYSENV, CFG_RTI_UPDATE_INDEX then putting RTI_UPDATE_INDEX_90 in line 1 and saving it, exiting OI 10 and restarting. This will force 10 to use 9 indexing logic.

We've been working a lot with indexes on large files in 10 and we'd recommend using this setting in any case if you're working with large data volumes. By large, we are talking tens of millions of rows.

The Sprezzatura Group

The Sprezzatura Blog

World leaders in all things RevSoft

Can this get moved to the works forum. I see vital information here.

Hi Andrew

Thank you ! This is so helpful

Hi Andrew,

Already follow your step, but It's still not working.

Regards,

Rudhy

View this thread on the forum...