Index update before search (AREV Specific) [Revelation On-Line Wiki]

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

At 19 APR 2000 02:18:31PM Frank Tomeo wrote:

AREV Specific

I realize that it is important to do an Index.Flush before any BTree.Extract statement for fear that recently updated data may not be indexed at the time the extract statement runs. However, is it necessary to run an Index.Flush before a REDUCE or a PERFORM "SELECT xxx" to be absolutely sure that all records are captured?

Thanks,

[email protected]

SRP Computer Solutions

At 19 APR 2000 02:57PM WinWin/Revelation Technical Support wrote:

Frank-

You don't need to run a flush before a select statement if the 'Update Indexes Before Filter' option in the environment is set to true.

Hope it helps-

Mike Ruane

At 19 APR 2000 05:18PM Frank Tomeo wrote:

View this thread on the forum...