视图中会使用基表的索引吗

Question

​我创建了一个视图View_CarrierGroup

```sql
SELECT   c.carrierid, (CASE WHEN ISNULL(cgg.id, 0) > 0 THEN cgg.id ELSE c.carrierid END) AS carrierGroupId, 
                (CASE WHEN ISNULL(cgg.id, 0) > 0 THEN cgg.carrierGroupName ELSE c.sname END) AS carrierGroupName, c.sname, 
                c.nname, c.cityid, c.address, c.zipcode, c.linkman, c.phone, c.mobile, c.fax, c.email, c.crperson, c.crtime, c.edperson, 
                c.edtime, c.status, c.btcflag, c.autoprintconfig, c.PrintCode, c.Reg_Mail_NO, c.carriertype, c.IsLDP, c.IsBoxUniQue, 
                c.codprintcode, c.ck_isReturnWeight, c.preSaleStatusRec, cgg.id, cgg.carrierGroupCode, cgg.carrierGroupPN, cgg.typeid, 
                cgg.houseid, cgg.edworkerid, cgg.remark
FROM      dbo.Carrier AS c LEFT OUTER JOIN
                    (SELECT   cg.id, cg.carrierGroupCode, cgd.carrierid, cg.carrierGroupName, cg.carrierGroupPN, cg.typeid, 
                                     cg.delflag AS cg_delflag, cg.houseid, cg.edworkerid, cg.remark
                     FROM      dbo.CarrierGroupDetail AS cgd LEFT OUTER JOIN
                                     dbo.CarrierGroup AS cg ON cg.id = cgd.carrierGroupid
                     WHERE   (cg.delflag = 0) AND (cgd.delflag = 0) AND (cg.typeid = '1')) AS cgg ON cgg.carrierid = c.carrierid

由于cgg表，无法增加索引

 
现有查询

Select top 5 * from do 
left join  View_CarrierGroup  on do.carrierid = View_CarrierGroup.carrierid
where View_CarrierGroup.carrierid=12

请问上面查询会使用 dbo.Carrier中的carrierid的索引吗

​

Answer 1

这个建议查看一下执行计划，可能会使用也可能不会使用，这个要看数据库本身的优化。会使用时，说明数据库自动进行了谓词内推