Are a different number of table indexes a "safe" definition mismatch in Pervasive/Btrieve

Posted on 2010-01-07
Medium Priority
Last Modified: 2013-12-25
I have need to add indexes to a customer's data tables. Since the data access method is Btrieve, each user's program would normally contain the file definition with the new indexes. In my case, many of the programs being written are in the beta stage so we don't wish to put the new program into production. That is, it is best if users continue to use the programs they have on their workstations.

Is it "safe" or accepted practice to add these new indexes to the end of the index list so that the new programs can use it while the old programs (without the index definition) continues to use the table with the previously existing indexes (which will not change)?

In MS Server and MySQL, it's common to add and remove table indexes on the fly. Will this work with Btrieve files? I will actually be adding the indexes with Pervasive SQL, but that should not be a factor.
Question by:digitron
LVL 18

Accepted Solution

mirtheil earned 2000 total points
ID: 26207216
It should not be a problem to add indexes after the pre-existing indexes. The only problem that might crop up would be if the file is recreated.  Any additional indexes would need to be recreated as well.  

Adding and removing indexes on the fly is possible but not recommended. When adding / removing indexes, you would want all users out of the system.

Author Closing Comment

ID: 31674409
Thanks. That's what I need to know. Some of the files are fairly large for Btrieve (5 million+ records) so I want to minimize rebuilds.

Featured Post

What is SQL Server and how does it work?

The purpose of this paper is to provide you background on SQL Server. It’s your self-study guide for learning fundamentals. It includes both the history of SQL and its technical basics. Concepts and definitions will form the solid foundation of your future DBA expertise.

Question has a verified solution.

If you are experiencing a similar issue, please ask a related question

In this series, we will discuss common questions received as a database Solutions Engineer at Percona. In this role, we speak with a wide array of MySQL and MongoDB users responsible for both extremely large and complex environments to smaller singl…
In this article, I’ll look at how you can use a backup to start a secondary instance for MongoDB.
This is a high-level webinar that covers the history of enterprise open source database use. It addresses both the advantages companies see in using open source database technologies, as well as the fears and reservations they might have. In this…
This lesson discusses how to use a Mainform + Subforms in Microsoft Access to find and enter data for payments on orders. The sample data comes from a custom shop that builds and sells movable storage structures that are delivered to your property. …
Suggested Courses

807 members asked questions and received personalized solutions in the past 7 days.

Join the community of 500,000 technology professionals and ask your questions.

Join & Ask a Question