Rebuild Indexes

[Mike Schwartz (PC Support & Servies)]

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