[[https://www.revelation.com/|Sign up on the Revelation Software website to have access to the most current content, and to be able to ask questions and get answers from the Revelation community]]


==== Can't Fix Index Problem Using OI 10 (OpenInsight 64-bit) ====
=== At 02 JUN 2022 10:22:03PM Rudhy B wrote: ===
 
{{tag>"OpenInsight 64-bit"}}
 
<QUOTE>
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. 



[img]https://optikseis.s3.ap-southeast-1.amazonaws.com/images/homepage/mainbanner/UD-OI.png[/img]





Thank You
</QUOTE>
----

=== At 06 JUN 2022 04:25AM Andrew McAuley wrote:  ===

<QUOTE>The way that indexing works in 10 is different [i]by default[/i] 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. 



[url=https://www.sprezzatura.com]The Sprezzatura Group[/url]

[url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url]

[i]World leaders in all things RevSoft[/i]

[img]https://www.sprezzatura.com/zz.gif[/img]

</QUOTE>

----

=== At 06 JUN 2022 05:26PM Barry Stevens wrote:  ===

<QUOTE>
<QUOTE>The way that indexing works in 10 is different [i]by default[/i] 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. 



[url=https://www.sprezzatura.com]The Sprezzatura Group[/url]

[url=https://www.sprezzatura.com/blog]The Sprezzatura Blog[/url]

[i]World leaders in all things RevSoft[/i]

[img]https://www.sprezzatura.com/zz.gif[/img]</QUOTE>





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

</QUOTE>

----

=== At 09 JUN 2022 07:43AM melia wrote:  ===

<QUOTE>Hi Andrew





Thank you ! This is so helpful 

</QUOTE>

----

=== At 18 JUN 2022 01:37AM Rudhy B wrote:  ===

<QUOTE>Hi Andrew,



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



[img]https://optikseis.s3.ap-southeast-1.amazonaws.com/images/homepage/mainbanner/18-2.png[/img]





Regards,



Rudhy





</QUOTE>


[[https://www.revelation.com/revweb/oecgi4p.php/O4W_HANDOFF?DESTN=O4W_RUN_FORM&INQID=NONWORKS_READ&SUMMARY=1&KEY=0DD6A5F82985D342A53C54BE1B9F85B7|View this thread on the  forum...]]