Skip to content

Smart auto-indexing #30

@jqnatividad

Description

@jqnatividad

Have an env var named QSV_AUTOINDEX.

It will be a string with three positions - PUI:

  • When P (for Primary Key) is 1, automatically create a primary key for a column with cardinality=rowcount, and there is no other column with cardinality=rowcount.
  • When U (for Unique Index) is 1, create a unique index for ALL columns where cardinality=rowcount.
  • When I (Index) is not zero, create an index for columns that have cardinality >= I.

Metadata

Metadata

Assignees

No one assigned

    Labels

    enhancementNew feature or request

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions