sql - 索引查询不够优化

Question

我正在尝试优化以下查询，但只能用时 10 秒。我试图在连接中涉及的外键表列上应用非聚集索引。有人可以让我知道我可以做些什么来加快查询速度吗？

select
    c.companyId, 
    c.companyName, 
    c.city, 
    cst.companyStatusTypeName,
    ct.companyTypeName,
    sc.simpleIndustryDescription,
    c.officeFaxValue, 
    c.officePhoneValue, 
    c.streetAddress,
    c.streetAddress2, 
    c.yearFounded,
    c.zipCode,
    c.webpage,
    rep.templateTypeName, 
    rcg.isoCountry2,
    rs.abbreviation
from ciqCompany c
    inner join ciqCompanyStatusType cst on cst.companystatustypeid = c.companystatustypeid
    inner join ciqCompanyType ct on ct.companyTypeId = c.companyTypeId
    inner join refReportingTemplateType rep on rep.templateTypeId = c.reportingtemplateTypeId
    inner join refCountryGeo rcg on c.countryId = rcg.countryId
    inner join refState rs on rs.stateId = c.stateId
    inner join ciqSimpleIndustry sc on sc.simpleIndustryId = c.simpleIndustryId

执行计划

表定义

Answer 1

尝试构建列存储索引:

https://learn.microsoft.com/en-us/sql/relational-databases/indexes/columnstore-indexes-data-warehouse