API 参考
    正在准备搜索索引...

    接口 TableIndexOptions

    Database's table index options.

    interface TableIndexOptions {
        columnNames: string[];
        isConcurrent?: boolean;
        isFulltext?: boolean;
        isNullFiltered?: boolean;
        isSpatial?: boolean;
        isUnique?: boolean;
        name?: string;
        parser?: string;
        where?: string;
    }
    索引

    属性

    columnNames isConcurrent? isFulltext? isNullFiltered? isSpatial? isUnique? name? parser? where?

    属性

    columnNames: string[]

    Columns included in this index.

    isConcurrent?: boolean

    Builds the index using the concurrently option. This options is only supported for postgres database.

    isFulltext?: boolean

    The FULLTEXT modifier indexes the entire column and does not allow prefixing. Supported only in MySQL & SAP HANA.

    isNullFiltered?: boolean

    NULL_FILTERED indexes are particularly useful for indexing sparse columns, where most rows contain a NULL value. In these cases, the NULL_FILTERED index can be considerably smaller and more efficient to maintain than a normal index that includes NULL values.

    Works only in Spanner.

    isSpatial?: boolean

    The SPATIAL modifier indexes the entire column and does not allow indexed columns to contain NULL values. Works only in MySQL.

    isUnique?: boolean

    Indicates if this index is unique.

    name?: string

    Constraint name.

    parser?: string

    Fulltext parser. Works only in MySQL.

    where?: string

    Index filter condition.

    显示设置

    成员可见性

    目录

    属性