How to use the "Create Database Index" option when editing a data structure?

taylor
edited May 29 in Datastructures

I am trying to use "Create Database Index" when editing a data structure and had some questions about how to configure this once it is enabled that isn't covered in documentation


Comments

  • The "Create Database Index" creates a column index for the field you're selecting in the database. For example, I have a Simple Data Structure named Index_Test. If you enable the 'Index Values Are Unique' option, it would change Index from 'Non-Unique, Non-Clustered' to 'Unique, Non-Clustered' This is typically useful if you're fetching based on the index columns alone to help speed up fetches.


Sign In or Register to comment.