Go Premium for a chance to win a PS4. Enter to Win

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1859
  • Last Modified:

How to create an index on a pervasive database table

Hello.

I have a Pervasive.SQL V10 database with a table that needs a new index.

I can create the index using the CREATE INDEX statement... but does this also populate the index or do I have to run a seperate command to do that?

Thanks.
0
soozh
Asked:
soozh
1 Solution
 
mirtheilCommented:
The CREATE INDEX statement will add the index to both the underlying data file and the DDF definitions making it available in both Btrieve and SQL.  If you add the "IN DICTIONARY" clause to the CREATE INDEX statement, only the dictionary definition is changed and does not affect the Btrieve file.  

0

Featured Post

Concerto Cloud for Software Providers & ISVs

Can Concerto Cloud Services help you focus on evolving your application offerings, while delivering the best cloud experience to your customers? From DevOps to revenue models and customer support, the answer is yes!

Learn how Concerto can help you.

Tackle projects and never again get stuck behind a technical roadblock.
Join Now