More than 1 year has passed since last update.

SQL ServerでCountが遅い時の代替方法（Indexの件数を取得する方法）

SQLServer

Last updated at 2022-02-18Posted at 2022-02-16

レコード件数が多すぎて、Countが遅いときに、Index件数で代替して速度向上

indexCount.sql

  SELECT
    i.name,
    i.rows
  FROM
    sysindexes as i
  INNER JOIN
    sysobjects o
    ON i.id = o.id
  WHERE
    o.xtype = 'U'
    AND i.name = N'PK名称'

You get articles that match your needs
You can efficiently read back useful information
You can use dark theme

What you can do with signing up