CREATE NONCLUSTERED INDEX [_dta_index_Movimientos_7_2034106287__K30_K13_K21_2_9_18] ON [dbo].[Movimientos]
(
	[Fecha_consolidacion_inventario] ASC,
	[No_inventariable] ASC,
	[Fk_centro] ASC
)
INCLUDE([E_S_N],[Articulo],[Cantidad]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Op_componentes_lotes_real_7_142623551__K3_7_12] ON [dbo].[Op_componentes_lotes_real]
(
	[Fk_articulo_componente] ASC
)
INCLUDE([Cantidad],[Fk_op]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_7_501576825__K46_K1_K2_K3_K5_K7_K14] ON [dbo].[Alb_venta_lineas]
(
	[Id_doc_asociado] ASC,
	[Id] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Fk_articulo] ASC,
	[No_inventariable] ASC,
	[Cantidad] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_venta_lineas_7_501576825__K7_K1_K2_K3_K5_K14] ON [dbo].[Alb_venta_lineas]
(
	[No_inventariable] ASC,
	[Id] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Fk_articulo] ASC,
	[Cantidad] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Op_Componentes_7_78623323__K2_K3_6] ON [dbo].[Op_Componentes]
(
	[Fk_op] ASC,
	[Fk_articulo_componente] ASC
)
INCLUDE([Cantidad]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_venta_lineas_7_910626287__K46_K1_K5_K2_K3_K14_47] ON [dbo].[Ped_venta_lineas]
(
	[Id_doc_asociado] ASC,
	[Id] ASC,
	[Fk_articulo] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Cantidad] ASC
)
INCLUDE([Cantidad_anulada]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Ped_venta_lineas_7_910626287__K14_K5_K1_2_3_47] ON [dbo].[Ped_venta_lineas]
(
	[Cantidad] ASC,
	[Fk_articulo] ASC,
	[Id] ASC
)
INCLUDE([Serie],[Numero],[Cantidad_anulada]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Facturas_venta_lineas_7_898102240__K46_K2_K3_K14] ON [dbo].[Facturas_venta_lineas]
(
	[Id_doc_asociado] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Cantidad] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Alb_compra_lineas_7_149575571__K46_K1_K2_K3_K5_K7_K14] ON [dbo].[Alb_compra_lineas]
(
	[Id_doc_asociado] ASC,
	[Id] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Fk_articulo] ASC,
	[No_inventariable] ASC,
	[Cantidad] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Fac_compra_lineas_7_578101100__K46_K2_K3_K14] ON [dbo].[Fac_compra_lineas]
(
	[Id_doc_asociado] ASC,
	[Serie] ASC,
	[Numero] ASC,
	[Cantidad] ASC
)WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO
CREATE NONCLUSTERED INDEX [_dta_index_Op_7_14623095__K15_K4_K21_K1_5_6] ON [dbo].[Op]
(
	[Estado] ASC,
	[Fk_articulo] ASC,
	[Fk_centro] ASC,
	[Id] ASC
)
INCLUDE([Cantidad],[Cantidad_real]) WITH (SORT_IN_TEMPDB = OFF, DROP_EXISTING = OFF, ONLINE = OFF) ON [PRIMARY]
GO

