I'm using Pervasive (v9.5) with some fairly large files. It would be convenient to be able to use external index files, but I can't figure out how to use them. I have used the Pervasive tools to create an external index file. My question is: How to I use Pervasive to actually use the file for reading data?
Pervasive built the file, but does not seem to recognize it as part of the database, though the file physically exists.
I've spent hours and hours in the documentation and find several reverences to using external index files, and examples of how to create them. Just no information on how to get the job done at runtime.
Do I have to take an extra step to associate the new index file with the original data file?
Once the association is made, does Pervasive automatically maintain the external index file?
Are there any special SQL commands that need to be included when starting a query?