declare @pgID money
set @pgID=629.4
    
SELECT source.fiiID, fiName
FROM (
SELECT Tovars.fiiID
        FROM Tovars WITH (NOLOCK)
        WHERE Tovars.pgID = @pgID
UNION
SELECT Tovars_Sup.fiiID
        FROM Tovars_Sup WITH (NOLOCK)
        WHERE Tovars_Sup.pgID = @pgID
UNION
SELECT 0
) As source
INNER JOIN Firm WITH(noLock) ON source.fiiID = Firm.fiiID
ORDER BY fiName

SELECT 
        DatabaseName = DB_NAME()
        ,TableName = OBJECT_NAME(s.[object_id])
        ,IndexName = i.name
        ,user_seeks
        ,user_lookups
        ,user_scans
        ,user_updates    
        ,system_updates 
FROM   sys.dm_db_index_usage_stats s 
INNER JOIN sys.indexes i ON  s.[object_id] = i.[object_id] 
    AND s.index_id = i.index_id 
WHERE  s.database_id = DB_ID()
    AND OBJECTPROPERTY(s.[object_id], 'IsMsShipped') = 0
    AND (i.name LIKE 'Индекс1' OR i.name LIKE 'Индекс2')

CREATE UNIQUE NONCLUSTERED INDEX [IX_Firm_fiName_unique] ON [dbo].[Firm] 
(
	[fiName] ASC
)
INCLUDE ( [fiUrl],
[usiID],
[fiiID])