1 2 3 4 5
| Rows Executes StmtText StmtId NodeId Parent PhysicalOp LogicalOp Argument DefinedValues EstimateRows EstimateIO EstimateCPU AvgRowSize TotalSubtreeCost OutputList Warnings Type Parallel EstimateExecutions
----------- ----------- --------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ----------- ----------- ----------- ------------------------------ ------------------------------ ----------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- ------------------------ ------------------------ ------------------------ ----------- ------------------------ ---------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------------- -------- ------------------------------ -------- ------------------------
60 1 SELECT * FROM [T_COMMANDE_CMD] WHERE [CMD_DATE]>=@1 AND [CMD_DATE]<=@2 18 1 0 NULL NULL NULL NULL 23.951853 NULL NULL NULL 7.8335598E-2 NULL NULL SELECT 0 NULL
60 1 |--Bookmark Lookup(BOOKMARK:([Bmk1000]), OBJECT:([DB_OPTIM].[dbo].[T_COMMANDE_CMD])) 18 3 1 Bookmark Lookup Bookmark Lookup BOOKMARK:([Bmk1000]), OBJECT:([DB_OPTIM].[dbo].[T_COMMANDE_CMD]) [T_COMMANDE_CMD].[CMD_FRAIS_LIVRAISON], [T_COMMANDE_CMD].[CMD_MONTANT_TAXES], [T_COMMANDE_CMD].[CMD_MONTANT_HT], [T_COMMANDE_CMD].[CMD_DATE_ECHEANCE], [T_COMMANDE_CMD].[CMD_MODE_PAIEMENT], [T_COMMANDE_CMD].[CMD_DATE], [T_COMMANDE_CMD].[CLI_ID], [T_COMMANDE 23.951853 7.1873344E-2 2.6347039E-5 77 7.8333206E-2 [T_COMMANDE_CMD].[CMD_FRAIS_LIVRAISON], [T_COMMANDE_CMD].[CMD_MONTANT_TAXES], [T_COMMANDE_CMD].[CMD_MONTANT_HT], [T_COMMANDE_CMD].[CMD_DATE_ECHEANCE], [T_COMMANDE_CMD].[CMD_MODE_PAIEMENT], [T_COMMANDE_CMD].[CMD_DATE], [T_COMMANDE_CMD].[CLI_ID], [T_COMMANDE NULL PLAN_ROW 0 1.0
60 1 |--Index Seek(OBJECT:([DB_OPTIM].[dbo].[T_COMMANDE_CMD].[X_CMD_DAT]), SEEK:([T_COMMANDE_CMD].[CMD_DATE] >= Convert([@1]) AND [T_COMMANDE_CMD].[CMD_DATE] <= Convert([@2])) ORDERED FORWARD) 18 5 3 Index Seek Index Seek OBJECT:([DB_OPTIM].[dbo].[T_COMMANDE_CMD].[X_CMD_DAT]), SEEK:([T_COMMANDE_CMD].[CMD_DATE] >= Convert([@1]) AND [T_COMMANDE_CMD].[CMD_DATE] <= Convert([@2])) ORDERED FORWARD [Bmk1000] 23.951853 6.3284999E-3 1.050147E-4 37 6.4335149E-3 [Bmk1000] NULL PLAN_ROW 0 1.0 |
Partager