I guess I do not understand SQL server is a transactional database also along with being a relational database. Please explain your answer. I am a little rusty with SQL server I haven't really used it in about a year.

The only additional activity I can think of is to purge old, un-needed records (closed SO, Closed PO's, Closed WO's) and consolidate transaction files (inventory transaction, general ledger transacton) before re-indexing.
 
Re-indexing not only rebuilds the internal table indexes, but, in the process, it recovers drive space from purged records.  The data files become smaller to the operating system.
 
As Loren pointed out, DBA uses only the transactional component of pervasive.  Because of this, the programs are written to sequentially step through each individual record of a table to process the data in that table.  Sometimes it steps through by following an index so that the records of interest get read right away (say, by date).  Other times, every record of the data file is read and compared with the selection criteria.  With Fewer records to read, programs that step through every record will take less time to run.

PO's would be BKAPHPO and BKAPHPOL and SO's would be BKARHINV and BKARHIVL.

Ooops, my bad...

Yes, you missed the work order files....

Look for all the files that start with WO (ie. WOROUT, WORKORD, etc.)

THANKS FOR ALL THE INFO.
 
Maybe auto-reindexing could be added to your "list".
 
lenette