Rebuild Indexes

[Ross Salas]

Hi Mike,

Thanks for the detailed explanation.  That really clears it up.

On Sat, Jan 11, 2020, 7:34 AM Mike Schwartz (PC Support & Servies) via
Filepro-list <filepro-list at lists.celestial.com> wrote:

> Hi Mike, thanks for the script!
>
>      When you say we have to rebuild the demand indexes manually, what do
> you mean?  And why only manually?
>
> Ross
> ----- ----- ------------------------------------
>
>      Demand indexes often use selection sets to select only part of the
> records.  If you have only a few demand indexes, you may want to rebuild
> them through the filePro menu index maintenance screen.
>
>      You could write a script to rebuild your demand indexes, but it would
> be a script where all the parameters to rebuild each index, including the
> selection set used, would have to be included on the command line.  For
> example, this screen build a demand index on my invoicing database:
>
>      dxmaint mjsinvoice -RF 14,4,a:20,14,a:1,20,a:2,20,a:11,10,a -oM -E -m
> ""
>
>      I see that Mark just sent you a list of option for the dxmaint
> lines.
>
>      You need one of these lines for each demand index on your system,
> *AND* you have to keep this script updated whenever you create or change
> any of your demand indexes.
>
> Mike
>
>
> _______________________________________________
> Filepro-list mailing list
> Filepro-list at lists.celestial.com
> Subscribe/Unsubscribe/Subscription Changes
> http://mailman.celestial.com/mailman/listinfo/filepro-list
>
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <http://mailman.celestial.com/pipermail/filepro-list/attachments/20200111/d70ae069/attachment.html>