Skip to content

Provide a way to define primary and secondary XML Indexes #1624

Open
@ashishs

Description

@ashishs

Exposed currently has no way to define xml indexes in MS SQL Server.

E.g:

CREATE PRIMARY XML INDEX [primary_xml_index_name] ON [table_name]([xml_column_1])

CREATE XML INDEX secondary_xml_index_name ON [table_name]([xml_column_1]) USING XML INDEX [primary_xml_index_name] FOR VALUE

Secondary xml indexes can be on PATH, VALUE, or PROPERTY
Documentation at XML Indexes

Note: a probable fix is to allow a listOf < DdlAware > objects to be added ad-hoc to a Table and have run after the table is created. The Index class is defined as a data class which prohibits subclassing.

Activity

Sign up for free to join this conversation on GitHub. Already have an account? Sign in to comment

Metadata

Metadata

Assignees

No one assigned

    Labels

    No labels
    No labels

    Type

    No type

    Projects

    No projects

    Milestone

    No milestone

    Relationships

    None yet

    Development

    No branches or pull requests

    Issue actions