import { Entity, Column, Index } from 'typeorm';
@Entity()
@Index('idx_name', ['name'])
export class User {
    @Column()
    name: string;
    @Column()
    age: number;
}

import { Entity, Column, Index } from 'typeorm';
@Entity()
@Index('idx_email', ['email'], { unique: true })
export class User {
    @Column()
    email: string;
    @Column()
    age: number;
}

import { Entity, Column, Index } from 'typeorm';
@Entity()
@Index('idx_name_age', ['name', 'age'])
export class User {
    @Column()
    name: string;
    @Column()
    age: number;
}

import { Injectable } from '@nestjs/common';
import { InjectRepository } from '@nestjs/typeorm';
import { Repository } from 'typeorm';
import { Location } from './location.entity';
@Injectable()
export class LocationService {
  constructor(
    @InjectRepository(Location)
    private readonly locationRepository: Repository<Location>,
  ) {}
  async createSpatialIndex(): Promise<void> {
    // 在SQL Server中創(chuàng)建空間索引的原生SQL語句
    const query = `
      CREATE SPATIAL INDEX IX_Location_Geometry 
      ON Location(Geometry) 
      WITH (BOUNDING_BOX = (xmin, ymin, xmax, ymax));
    `;
    await this.locationRepository.query(query);
  }
}

import { Injectable } from '@nestjs/common';
import { InjectRepository } from '@nestjs/typeorm';
import { Repository } from 'typeorm';
import { User } from './user.entity';
@Injectable()
export class UserService {
  constructor(
    @InjectRepository(User)
    private readonly userRepository: Repository<User>,
  ) {}
  async createFullTextIndex(): Promise<void> {
    // 在SQL Server中創(chuàng)建全文索引的原生SQL語句
    const query = `
      CREATE FULLTEXT INDEX ON User(name) KEY INDEX PK_User;
    `;
    await this.userRepository.query(query);
  }
}