• Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 1967
  • 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
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

Join & Write a Comment

Featured Post

Cloud Class® Course: Python 3 Fundamentals

This course will teach participants about installing and configuring Python, syntax, importing, statements, types, strings, booleans, files, lists, tuples, comprehensions, functions, and classes.

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