select distinct it.ID_InventoryTag,it.id_dovidnykTovarivfirmy,
	  it.RateOfTaxBuying,so.ID_SalesOutlet,so.TypeBaseCinaPidrozdil from
	  InventoryTag as it join PidrozdilFirmy as pf on(pf.ID_PidrozdilFirmy = it.ID_PidrozdilFirmy) join
	  SalesOutlet as so on(so.ID_SalesOutlet = pf.ID_SalesOutlet) join
	  ZalyshokTMC as ztmc on(ztmc.ID_Inventorytag = it.ID_InventoryTag) where
	  ztmc.ID_Zalyshky = any(select a.ID_Zalyshky from Analityka as a where a.ID_Document = @id_document) and
	  pf.TypeRegistrationCost =  1   and it.id_rahunok =  215 

QUERY PLAN FOR STATEMENT  1  (at line  1 ).


    STEP  1 
        The type of query is SELECT.

        FROM TABLE
            Analityka
            a
        Nested iteration.
        Index : ix_document_zalyshky
        Forward scan.
        Positioning by key.
        Index contains all needed columns. Base table will not be read.
        Keys are:
            ID_Document  ASC
        Using I/O Size  16  Kbytes for index leaf pages.
        With LRU Buffer Replacement Strategy for index leaf pages.

        FROM TABLE
            ZalyshokTMC
            ztmc
        Nested iteration.
        Index : AK_KEY_2_ZALYSHOK2
        Forward scan.
        Positioning by key.
        Keys are:
            ID_Zalyshky  ASC
        Using I/O Size  2  Kbytes for index leaf pages.
        With LRU Buffer Replacement Strategy for index leaf pages.
        Using I/O Size  2  Kbytes for data pages.
        With LRU Buffer Replacement Strategy for data pages.

        FROM TABLE
            InventoryTag
            it
        Nested iteration.
        Using Clustered Index.
        Index : PK_INVENTORYTAG
        Forward scan.
        Positioning by key.
        Keys are:
            ID_InventoryTag  ASC
        Using I/O Size  2  Kbytes for index leaf pages.
        With LRU Buffer Replacement Strategy for index leaf pages.
        Using I/O Size  2  Kbytes for data pages.
        With LRU Buffer Replacement Strategy for data pages.

        FROM TABLE
            PidrozdilFirmy
            pf
        Nested iteration.
        Using Clustered Index.
        Index : PK_PIDROZDILFIRMY
        Forward scan.
        Positioning by key.
        Keys are:
            ID_PidrozdilFirmy  ASC
        Using I/O Size  2  Kbytes for data pages.
        With LRU Buffer Replacement Strategy for data pages.

        FROM TABLE
            SalesOutlet
            so
        Nested iteration.
        Using Clustered Index.
        Index : PK_SALESOUTLET
        Forward scan.
        Positioning by key.
        Keys are:
            ID_SalesOutlet  ASC
        Using I/O Size  2  Kbytes for index leaf pages.
        With LRU Buffer Replacement Strategy for index leaf pages.
        Using I/O Size  2  Kbytes for data pages.
        With LRU Buffer Replacement Strategy for data pages.